Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Clustered-Stacked-Column Combo Chart With Lines
Hello,
I'm hoping you'll be able to help me with this... I have multiple charts (Clustered-Stacked-Column Combo Chart With Lines) with the same layout and currently I have to manually update them .... one series at a time (7 in each chart and 30 charts).... :o( I would like to automate this as much as possible. I have a data range from Jan 09 to Dec 2010... However the line series of the charts reference another data table. I would like to specify the Start point and End point of the chart (12month rolling). The issue herein lies that these charts have already been created and I am wanting to modify(automate) these as the format and detail work. I'm using excel 2003. The link is an example of the charts I am working with Many thanks Tracey http://peltiertech.com/WordPress/clu...rt-with-lines/ |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Clustered-Stacked-Column Combo Chart With Lines
Check out Jon's articles on Dynamic charting:
http://peltiertech.com/Excel/Charts/Dynamics.html maybe specifically: http://peltiertech.com/Excel/Charts/DynamicLast12.html Granted, with that many charts and different tables, you'll need to setup quite a few named ranges, but it should be worth it in the end to have a nice automatically updating workbook. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tracey" wrote: Hello, I'm hoping you'll be able to help me with this... I have multiple charts (Clustered-Stacked-Column Combo Chart With Lines) with the same layout and currently I have to manually update them .... one series at a time (7 in each chart and 30 charts).... :o( I would like to automate this as much as possible. I have a data range from Jan 09 to Dec 2010... However the line series of the charts reference another data table. I would like to specify the Start point and End point of the chart (12month rolling). The issue herein lies that these charts have already been created and I am wanting to modify(automate) these as the format and detail work. I'm using excel 2003. The link is an example of the charts I am working with Many thanks Tracey http://peltiertech.com/WordPress/clu...rt-with-lines/ |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Clustered-Stacked-Column Combo Chart With Lines
Hi,
Since the default setting in Excel is to plot visible cells only, you can apply a filter to your data ranges and the chart will plot only the displayed data. For example a column called Date could have a AutoFilter applied. Then choose Custom from the filter and choose "is greater than or equal to" from the first drop down and enter a starting date to the right. Choose And as the operator and "is less than or equal to for the second condition and enter your ending date. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Tracey" wrote: Hello, I'm hoping you'll be able to help me with this... I have multiple charts (Clustered-Stacked-Column Combo Chart With Lines) with the same layout and currently I have to manually update them .... one series at a time (7 in each chart and 30 charts).... :o( I would like to automate this as much as possible. I have a data range from Jan 09 to Dec 2010... However the line series of the charts reference another data table. I would like to specify the Start point and End point of the chart (12month rolling). The issue herein lies that these charts have already been created and I am wanting to modify(automate) these as the format and detail work. I'm using excel 2003. The link is an example of the charts I am working with Many thanks Tracey http://peltiertech.com/WordPress/clu...rt-with-lines/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clustered and Stacked Column Chart | Excel Discussion (Misc queries) | |||
Stacked/clustered column chart with a two vertical axes | Charts and Charting in Excel | |||
Combined: Clustered-Stacked Column Chart | Charts and Charting in Excel | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel |