software

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

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Excel is assuming you want your bars displayed according to the dates.
gt; To get back to a category axis select chart and right click. From the
gt; popup menu select Chart Options. On the Axes tab set the x axis to
gt; Category rather than Automatic or Time series.
gt;
gt; Cheers
gt; Andy
gt;
gt; Dredd wrote:
gt; gt; Seeing a weird thing. When I create a stacked bar or column chart, I get bars
gt; gt; that are one pixel wide so it looks like a vertical line.
gt; gt; Closed the sheet, re-opened, new sheet, new data, nothing works.
gt; gt; If I embed a worksheet in Powerpoint, and in that sheet, create a new
gt; gt; worksheet with the data, it works fine... Baffles me !!
gt; gt; Also, excel seems incapable of creating a graph with dates on the X axis, li
gt; gt; lists them as ascending numbers, 1.2.3 etc.
gt; gt; Again, works fine in an embedded spreadsheet in Powerpoint. As they use the
gt; gt; same graph engine, I'm stumped.
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;