chart type keeps changing

[Guest]

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??

 

[Jon Peltier]

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/
_______