Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart type keeps changing
My chart is "embedded" in my worksheet. The worksheet has months across the
top in one row and net income per share in a row below it for each corresponding month. The x-axis is pulling data for the month and year eg. Jan-04...Feb-06. The y-axis is pulling data from a different row for the net income for each month. The chart has been maintained since Jan-04. It is a standard clustered column w/ a 3-D visual effect. I am trying to enter data for March '06 in data source, series one. I am updating the series 1 with the new column address that represents the new month eg. February vs. March. When I enter this data the whole graph immediately turns to black & white with skinny lines for the chart instead of the colored 3-D. The chart-type still says it's a clustered column but it's not. Also, the chart no longer shows my Jan .'06 data anywhere. What am I doing wrong?? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart type keeps changing
The chart type isn't changing, but suddenly Excel is trying to apply a
date-scale axis instead of the category type you had previously. The narrow bars are caused by an assumed base unit of days. You could either double click the axis and on the scale tab change this to months, or you could go to Chart Options on the Chart menu, click on the Axes tab, and change the category axis to Category. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jbear" wrote in message ... My chart is "embedded" in my worksheet. The worksheet has months across the top in one row and net income per share in a row below it for each corresponding month. The x-axis is pulling data for the month and year eg. Jan-04...Feb-06. The y-axis is pulling data from a different row for the net income for each month. The chart has been maintained since Jan-04. It is a standard clustered column w/ a 3-D visual effect. I am trying to enter data for March '06 in data source, series one. I am updating the series 1 with the new column address that represents the new month eg. February vs. March. When I enter this data the whole graph immediately turns to black & white with skinny lines for the chart instead of the colored 3-D. The chart-type still says it's a clustered column but it's not. Also, the chart no longer shows my Jan .'06 data anywhere. What am I doing wrong?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent user changing pivot chart layout | Excel Worksheet Functions | |||
Line Chart - 2 | Charts and Charting in Excel | |||
Which type of chart would you suggest to use? | Charts and Charting in Excel | |||
Pie chart - type | Charts and Charting in Excel | |||
How to prevent Excel 2003 from automatically change chart type | Charts and Charting in Excel |