Software

Ask something
Discussion Locked

Excel 97 Charts

0 helpful
4 replies

by simon30

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
A user of ours wants to have a mixed chart (columns & Lines), has 5 items of data. Instead of (custom Type chart Line-Column)defaulting to 3 columns & 2 lines plotted; would like it to display 4 colunms & 1 line? I have attempted to see if it can bemodified in excel 97&2000, don't think its possible - just asking incase there is a workaround?

4 replies

by kees.valkenswaard

Yes, it is possible.
It is a little bit complicated to explain all details. You would have to experiment yourself or send me the file [perhaps ZIPped]
Once you have made the graph with the three columns and 2 lines, click on the line you want to change. You can see if you did correct by the fact that there should be dark square boxes on the line. Else click somewhere else and try again.
Right click and choose graph type. Change it to bar.
Now you probably have the problem that the bars willbe overlapping.
Choose again each set of bars. Right click and choose format. There on the Tab page Options you can play with overlap and width between bars. You may have to do this for each set of bars. Once the bars are next to each other you have your solution.
Good luck.

by kees.valkenswaard

To be fair, I checked it. With four it is simple. With five it may nearly be impossible. You probably would have to work with a secondary X-axis which you would have to shift [different starting point or where it would cut the Y-axis] in order to get something.
It may be better to tell exactly what you want and why before doing a lot of effort. Often there is a different solution to the same problem.

by simon30

advice works with a little layout modification. Appreciate the advice as other support sites were of little help.

This discussion is closed to new replies.