Problems with Stacked Bar charts

[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.

[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

Dredd wrote:
> 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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

[Dredd]

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

"Andy Pope" wrote:

> 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
>
> Dredd wrote:
> > 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.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>