Clustered-Stacked-Column Combo Chart With Lines

[Tracey]

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).... (
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/

 

[Luke M]

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.

 

[Shane Devenshire]

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.