Excel Graphs

Nefarious

Nefarious

Nefarious

Associate
Joined
1 Aug 2003
Posts
1,053
Excel will produce what it calls a stacked column graph, where it will take a series of values and place them in one bar but have multiple bars for say a time period (i.e. number of chocolate confectionary with different coloured sections for different types with each bar on the graph representing how many total bars were eaten by one obese butter ball).

Is there anyway to get it to concatonate the bars instead of having spaces in-between them? So that it is more like a stacked area graph but with nicely notched tops?
 
So you want histograms not bar charts?

I've got Office 2000 but I think I've found the answer. Take your data and make a bar chart as normal. Then right click on one of the bars and choose "Format Data Series". Go to the Options tab. There should be a setting for "Gap width". Excel 2000 has it at 150 on my PC. Set the gap to 0 and the bars should now touch each other as a histogram.

*Edit* Just for the record, OpenOffice appears to be a bit trickier.

http://www.openoffice.org/servlets/ReadMsg?list=users&msgNo=55020
 
Last edited:
Interestingly it doesn't work....

It makes the bars broader but they don't touch (for some inexplicable reason)
Another nice bit of sensible programming from M$ ;)
 
Last edited:
How very droll..... the version of Office is 2000 - I have nowhere on the net to post the image so descriptions will have to suffice.

Overlap is set to 100
Gap width is set to 0

Perhaps it has something to do with the data sets that I'm using?
 
Nefarious said:
How very droll..... the version of Office is 2000 - I have nowhere on the net to post the image so descriptions will have to suffice.

Overlap is set to 100
Gap width is set to 0

Perhaps it has something to do with the data sets that I'm using?
Click to expand...
Hehe. Could be.
 
You must log in or register to reply here.
Back
Top Bottom