LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jbear
 
Posts: n/a
Default 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??


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent user changing pivot chart layout Jessica Excel Worksheet Functions 0 April 15th 06 12:24 AM
Line Chart - 2 Aurora Charts and Charting in Excel 1 March 8th 06 09:22 PM
Which type of chart would you suggest to use? Jenny Charts and Charting in Excel 1 February 17th 06 04:48 AM
Pie chart - type Cowtoon Charts and Charting in Excel 3 October 11th 05 10:24 PM
How to prevent Excel 2003 from automatically change chart type Oscar II Charts and Charting in Excel 2 October 1st 05 02:57 PM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"