Clustered-Stacked-Column Combo Chart With Lines
in [Charts]
|
Prev: Excel 2007 Pivot charts, any way to display filters on the chart?
Next: Chart series legend font size keeps shrinking - how to stop it?
From: Tracey on 4 Feb 2010 10:53 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/clustered-stacked-column-combo-chart-with-lines/
From: Luke M on 4 Feb 2010 11:44 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/clustered-stacked-column-combo-chart-with-lines/
From: Shane Devenshire on 5 Feb 2010 16:48
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/clustered-stacked-column-combo-chart-with-lines/ |