If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems with Stacked Bar charts
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. |
#2
|
|||
|
|||
Problems with Stacked Bar charts
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 |
#3
|
|||
|
|||
Problems with Stacked Bar charts
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked charts misalign when printed | Hans | Charts and Charting | 3 | August 26th, 2005 06:30 AM |
Double 100% Stacked column charts | buggy | Charts and Charting | 2 | July 7th, 2005 09:14 PM |
Column Charts - stacked and grouped | jtd1 | Charts and Charting | 2 | April 10th, 2005 10:48 PM |
total value of stacked charts | OkieViking | Charts and Charting | 1 | January 28th, 2005 12:57 PM |
Problems with Pivot Charts | Steve | General Discussion | 0 | January 13th, 2005 09:55 AM |