Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bret Davis
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing the color of a single bar on a graph Brian Charts and Charting in Excel 1 November 22nd 05 04:55 PM
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error Chrism Excel Discussion (Misc queries) 4 May 4th 05 04:06 PM
changing a range of fields Mr. G. Excel Discussion (Misc queries) 3 January 31st 05 09:21 PM
Changing Graph Title W/ Pivot Jenn Excel Discussion (Misc queries) 1 January 19th 05 03:42 AM
changing the value of each cell in a range by a certain percentage Aaron Excel Discussion (Misc queries) 5 December 15th 04 10:30 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"