Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have a chart automatically adjust range as I add data entri
I have a spreadsheet linked to an access database. The spreadsheet refreshes
every 60 seconds automatically. I want to track current performance by using a chart that shows the last 25 data points entered. It is impractical to manually change the chart range each time a data entry is added. How can I make it change automatically to only include the last 25 entries? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have a chart automatically adjust range as I add data entri
I got an similar problem. I'm triing to make a simple macro wich import a
..txt file and build a histogram chart. However my number of line varies, wich leave blank when the file imported is smaller or doesn't show additional lines... I tried to use in the edition menu ''go to'' then click ''cells'' and you choose only cells that are constant (or something else). It works but once it's record in the macro it keeps the same number of line when I recorded it. And there also an error in selection? It might work for you if you doiing your chart manually. So if you have any other idea would you please mail me. Thanks, Alex "AdamCPTD" wrote: I have a spreadsheet linked to an access database. The spreadsheet refreshes every 60 seconds automatically. I want to track current performance by using a chart that shows the last 25 data points entered. It is impractical to manually change the chart range each time a data entry is added. How can I make it change automatically to only include the last 25 entries? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have a chart automatically adjust range as I add data entri
You can make a dynamic name range, and use that as source data. If your data
was in column A in Sheet1, with A1 as header: =OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-26,0,25,1) would be the formula to use for the dynamic range. You can adjust the reference to fit your situation. -Simon "AdamCPTD" wrote: I have a spreadsheet linked to an access database. The spreadsheet refreshes every 60 seconds automatically. I want to track current performance by using a chart that shows the last 25 data points entered. It is impractical to manually change the chart range each time a data entry is added. How can I make it change automatically to only include the last 25 entries? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add data outside chart range | Charts and Charting in Excel | |||
automatically expand chart data series as data is added | Charts and Charting in Excel | |||
A Chart that Updates Automatically as Data Size Changes? | Charts and Charting in Excel | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
re-selection of Chart data range using keyboard | Excel Worksheet Functions |