Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Data Range in Chart
I have a spreadsheet that I continually add data to. I have a chart
based on the data. My problem is I want the chart to only show the last 5 data points entered in the spreadsheet and continue to do so ass I add more data. Example Data: LOT NUMBER DATA 1 13 2 12 3 14 4 12 5 13 6 15 As I add data I want the chart to show only the last 5 entries. Is there a simple way to do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Data Range in Chart
Peter:
This is pretty straight forward You simply need to set up dynamic range names for your X and Y variables. The linked tutorial shows you an example dynamic XY chart that will automatically plot the last number of data items that you specify. http://processtrends.com/pg_dynamic_charts.htm If you have any questions about this example, let me know. ....Kelly "Peter" wrote in message ups.com... I have a spreadsheet that I continually add data to. I have a chart based on the data. My problem is I want the chart to only show the last 5 data points entered in the spreadsheet and continue to do so ass I add more data. Example Data: LOT NUMBER DATA 1 13 2 12 3 14 4 12 5 13 6 15 As I add data I want the chart to show only the last 5 entries. Is there a simple way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add data outside chart range | Charts and Charting in Excel | |||
insert data labels from range not used in chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions |