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: 2
Default source data of varying sizes

I have multiple columns of data, which are all the same length, and
correspond to a specific act. This data is charted and gives multiple
graphical anlyses. Currently, I copy the entire worksheet and paste to
another tab in the same workbook when I have another set of data to chart
from a different act. The data always starts in the same cells but the
length always varies, sometimes more and sometimes less. Can I define the
source data range as "start cell : end+down" so I don't have to redefine
every time?
 
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
Looking up data with varying Lookup_value jake Excel Worksheet Functions 3 September 14th 07 09:06 AM
transposing vertical data to horizontal with varying amount of data Ghosty Excel Discussion (Misc queries) 5 August 1st 06 05:20 AM
Varying data on X axis coa01gsb Charts and Charting in Excel 2 February 6th 06 02:48 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 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 02:33 AM.

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

About Us

"It's about Microsoft Excel"