View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bandit292 Bandit292 is offline
external usenet poster
 
Posts: 1
Default Static Chart Data Range

Excel-2007, simple line chart:

I have a chart that displays several columns of data for rows 2:84. Whenever
I insert a new row #2, the new data range for the chart is now 3:85. How do I
keep a static data range for my chart (2:84) whenever I insert new rows into
the workbook?

I have tried editing $A$2:$E$84 to A2:E84 and then saving the changes ...
but it is an excercise in futility, it always reverts back to $A$2:$E$84.