View Single Post
  #1   Report Post  
maryj
 
Posts: n/a
Default data source remain constant

I have line chart that uses values in column C. Periodically I insert a new
column of data which then becomes the new column C. Now the chart is
displaying the data in column D but would like it to always chart the values
in C. I tried removing the absolute references in the source data but it
won't allow that. Other suggestions?
--
maryj