LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default Trying to define a changing range for chart

Hello,

I'm currently working on a MS Excel worksheet where I constantly have data
entered in. Now, I want to keep all of the data, but only want to graph the
last 10 values. I tried programming this, but from what I understand I'll
have to create the graph every time, which is not feasible. Is it possible to
get excel to do this for me and how? I have almost no understanding of VBA if
this is the course to take.

Thanks in advance,

RC
 
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
define max in range (macro) Steve Excel Discussion (Misc queries) 3 January 7th 09 01:55 AM
Define a range jlclyde Excel Discussion (Misc queries) 2 April 17th 08 08:26 PM
Pivot Chart, changing the range of data weekly How to autopopulate a drop down list[_2_] Charts and Charting in Excel 1 December 12th 07 10:22 AM
Define chart range using indirect reference Thomas Charts and Charting in Excel 3 May 10th 06 09:44 PM
Define a range based on another named range Basil Excel Worksheet Functions 2 February 21st 05 01:47 PM


All times are GMT +1. The time now is 05:40 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"