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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
source data of varying sizes
If you're using Excel 2003, select the data and convert it to a list, and
base the chart on data in the list. Then copy this whole sheet, chart and list and all. Replace the data in the sheet with the new data, and resize the list to contain the data. The chart will update as the list changes size. In Excel 2007 the approach is similar, except the list is now called a table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "materials scientist" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
source data of varying sizes
Each set of data is fixed and has no further additions or deletions, however,
the size varies from one set to the next. I'm trying to minimize the manipulation I have to do to each new set of data for the charts to present what I want. The data will always start in the same cell but will finish in a different row. I want the chart to plot data starting in a fixed cell and continuing down to the end of the data without manually resizing. Thanks for your help. "Jon Peltier" wrote: If you're using Excel 2003, select the data and convert it to a list, and base the chart on data in the list. Then copy this whole sheet, chart and list and all. Replace the data in the sheet with the new data, and resize the list to contain the data. The chart will update as the list changes size. In Excel 2007 the approach is similar, except the list is now called a table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "materials scientist" wrote in message ... 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? |
Reply |
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) |