Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data selection on line chart
I'm collecting data but only want to chart the last 60 points on my line chart. To do this I have to manually update the series value information in the source data. for example: I have 176 rows of data and the chart series value is "=sheet1$b$117:$b$176" if I add a new row I have to change this to "=sheet1$b$118:$b$177". Is there any way to use a variable for this? say LRD is the last row of data could I change this value statement to be "=sheet1$b$(LRD-59):$b$(LRD) so that anytime I add a new row it would update the chart? thanks, Q -- Qiset ------------------------------------------------------------------------ Qiset's Profile: http://www.excelforum.com/member.php...o&userid=25865 View this thread: http://www.excelforum.com/showthread...hreadid=394545 |
#2
|
|||
|
|||
Hi,
You need to use dynamic named ranges. See Jon's explanation which you can modify to plot the last 60 instead of last 12 periods. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy Qiset wrote: I'm collecting data but only want to chart the last 60 points on my line chart. To do this I have to manually update the series value information in the source data. for example: I have 176 rows of data and the chart series value is "=sheet1$b$117:$b$176" if I add a new row I have to change this to "=sheet1$b$118:$b$177". Is there any way to use a variable for this? say LRD is the last row of data could I change this value statement to be "=sheet1$b$(LRD-59):$b$(LRD) so that anytime I add a new row it would update the chart? thanks, Q -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Perfect! Many thanks! Q -- Qiset ------------------------------------------------------------------------ Qiset's Profile: http://www.excelforum.com/member.php...o&userid=25865 View this thread: http://www.excelforum.com/showthread...hreadid=394545 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel |