Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up data with varying Lookup_value | Excel Worksheet Functions | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
Varying data on X axis | Charts and Charting in Excel | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |