Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 10
Default Source Range

I have a sheet with four columns of data. The first column is date/time
information for the X-Axis. Every day, two new rows are added at the bottom.
I have to manually change the source data range each time to include these
newly added rows of data. Is there a way to specify that all rows containing
data are to be included? I could specify, say, one-hundred additional rows
but that would create a large empty area at the right side of the chart and
unnecessarily compress the data to the left. Is there an alternate solution?

Thanks in advance for any comments,
/s/ Alan Auerbach
 
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
Using a Named Range for Data Source In A Chart JoeP Charts and Charting in Excel 2 April 25th 07 02:33 AM
CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE Angelica Excel Discussion (Misc queries) 2 August 3rd 06 07:35 PM
Problem setting SeriesCollections source range Lead Foot Charts and Charting in Excel 2 January 27th 06 05:11 AM
How to identify source or location of MAX_VALUE in range Phil Excel Worksheet Functions 5 March 7th 05 11:21 PM
How can i set the source-data-range of pivottable2 to the source . Piet Excel Discussion (Misc queries) 0 March 5th 05 09:31 PM


All times are GMT +1. The time now is 03:03 AM.

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"