Problems with Stacked Bar charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top