Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping a series table from updating when adding new rows.
I have a spreadsheet where the information begins at row 5 and carries on for
many more rows. The information is ranked with row 5 representing the latest information, and the bottom row representing the oldest information. If I have a chart that plots the "latest five values" (a5:a10), then I decide to insert a new row 5, representing the very latest update, how do I keep Excel from automatically updating the chart to plot a6:a11? I want it to stay a5:a10, incorporating the latest row insert and dropping the oldest. |
#2
|
|||
|
|||
You could adapt the dynamic chart technique that Jon Peltier describes he
http://www.peltiertech.com/Excel/Cha...micLast12.html Jacen Saracen wrote: I have a spreadsheet where the information begins at row 5 and carries on for many more rows. The information is ranked with row 5 representing the latest information, and the bottom row representing the oldest information. If I have a chart that plots the "latest five values" (a5:a10), then I decide to insert a new row 5, representing the very latest update, how do I keep Excel from automatically updating the chart to plot a6:a11? I want it to stay a5:a10, incorporating the latest row insert and dropping the oldest. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
based on peltier;s dynamic range (referreed to by Debra Dalgleish) use
something like this =OFFSET(INDIRECT("Sheet1!$A$5"),0,0,6,1) Debra Dalgleish wrote in message ... You could adapt the dynamic chart technique that Jon Peltier describes he http://www.peltiertech.com/Excel/Cha...micLast12.html Jacen Saracen wrote: I have a spreadsheet where the information begins at row 5 and carries on for many more rows. The information is ranked with row 5 representing the latest information, and the bottom row representing the oldest information. If I have a chart that plots the "latest five values" (a5:a10), then I decide to insert a new row 5, representing the very latest update, how do I keep Excel from automatically updating the chart to plot a6:a11? I want it to stay a5:a10, incorporating the latest row insert and dropping the oldest. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Pivot Table not Updating | Excel Worksheet Functions | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
Adding a formula to a pivot table | Excel Discussion (Misc queries) |