If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically changing the range in a graph
I constantly add data to a spreadsheet and I want to only graph the last 24
data points with out constantly cahnging the graph range. How do I do this? |
#2
|
|||
|
|||
Automatically changing the range in a graph
Jon Peltier has instructions for a dynamic chart:
http://www.peltiertech.com/Excel/Cha...tml#DynoLast12 Bret Davis wrote: I constantly add data to a spreadsheet and I want to only graph the last 24 data points with out constantly cahnging the graph range. How do I do this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing Links for msoEmbeddedOLEobject (MS Graph) | Rodp | Powerpoint | 3 | September 20th, 2005 09:11 AM |
changing Axis properties in graph | dshemesh | Setting Up & Running Reports | 1 | September 6th, 2005 02:39 PM |
How do you copy RANK w/o it changing the range? | jspan | Worksheet Functions | 1 | June 21st, 2005 02:56 AM |
Changing cell references in graph range (or any formula for that matter) | Allan Howden | Setting up and Configuration | 1 | July 2nd, 2004 10:25 AM |
Changing bar graph legend? | Debra Dalgleish | Charts and Charting | 2 | March 8th, 2004 03:04 AM |