I want my chart to update automatically as I add additional data to a column. I understand that we can revise the Series to use a formula. I believe it needs to use Offset in combination with Count, but can't work out the precise formula. Does anyone remember this formula? Thanks, Andy.
Results 1 to 2 of 2
Thread: Automatic charting (2002)
-
5 Star Lounger
- Join Date
- Mar 2001
- Posts
- 989
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-03-03 13:57Automatic charting (2002)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Silver Lounger
- Join Date
- Mar 2001
- Location
- Springfield, Ohio, USA
- Posts
- 2,136
- Thanks
- 0
- Thanked 1 Time in 1 Post
2004-03-13 16:04Re: Automatic charting (2002)
(Edited by HansV to update link to Excel MVP site)
You are correct about offset. Jan Karl's download, AutoChrt.zip, at http://www.bmsltd.ie/mvp/MVPPage.asp#JanKarelPieterse shows you how. HTH --Sam<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>
