dynamic charts

[efader]

Hi:

I have a series of monthly reports within excel. Each of those
reports has a raw data tab. The raw data goes from left to right and
each column represents an additional month. The rows represent
different metrics that are tracked over time.

How can I create my charts so that when I add an additional months
worth of data (ex: adding a column to the raw data table) the charts
dynamically update with a rolling 13 month trend?

I have seen other examples where the raw data is setup differently and
can't format my data that way. Specifically, people had the months in
each row and the metrics across the columns.

Thanks,
Eric

 

[Gord Dibben]

See Tushar Mehta's site for a short course on Dynamic Charting and some sample
files.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Alternative site is Stephen Bullen's.

http://www.oaltd.co.uk/Excel/Default.htm

Download either or both of FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP

 

[efader]

See Tushar Mehta's site for a short course on Dynamic Charting and some sample
files.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Alternative site is Stephen Bullen's.

http://www.oaltd.co.uk/Excel/Default.htm

Download either or both of FunChrt1 and FunChrt7

Gord Dibben MS Excel MVP









- Show quoted text -

Unfortunately, those all have data incrementing by rows. I need an
example where data increments by columns.