Problems with Stacked Bar charts

D

Dredd

Seeing a weird thing. When I create a stacked bar or column chart, I get bars
that are one pixel wide so it looks like a vertical line.
Closed the sheet, re-opened, new sheet, new data, nothing works.
If I embed a worksheet in Powerpoint, and in that sheet, create a new
worksheet with the data, it works fine... Baffles me !!
Also, excel seems incapable of creating a graph with dates on the X axis, li
lists them as ascending numbers, 1.2.3 etc.
Again, works fine in an embedded spreadsheet in Powerpoint. As they use the
same graph engine, I'm stumped.
 
A

Andy Pope

Hi,

Excel is assuming you want your bars displayed according to the dates.
To get back to a category axis select chart and right click. From the
popup menu select Chart Options. On the Axes tab set the x axis to
Category rather than Automatic or Time series.

Cheers
Andy
 
D

Dredd

Andy.... You are a star..... THANKS :)

Andy Pope said:
Hi,

Excel is assuming you want your bars displayed according to the dates.
To get back to a category axis select chart and right click. From the
popup menu select Chart Options. On the Axes tab set the x axis to
Category rather than Automatic or Time series.

Cheers
Andy
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Stacked bar charts 1
Combination Stacked Bar and Line Graph 1
Stacked bars with textlegends in each stacked bar 7
How to set up stacked bar charts with 2 axis? 1
Creating a stacked column graph 2
Dynamic stacked bar chart not working 3
Stacked Bar and Line on Same Graph 2

Top