| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Static Range Reference | Excel Discussion (Misc queries) | |||
| How do i export a pivot chart as a static chart object? | Charts and Charting in Excel | |||
| How to put a STATIC version of a range of cells into an Outlook em | Excel Discussion (Misc queries) | |||
| My chart automatically updates, but how can i keep it within a static date range???? | Charts and Charting in Excel | |||
| Dynamic data, static range, not updating. | Charts and Charting in Excel | |||
Threaded Mode
