Changing the data for multiple EXCEL charts

[Anders]

My problem is the following:
I have a big matix of data with the folowing structure:

Jan Feb Mar ...
data1 ... ... ... ...
data2 ... ... ... ...
data3 ... ... ... ...
....

From this matrix I have generated a big number of charts
with different data vs. the months, i.e. months on the X-
axis.
Now I want to change the period of time I show in all
charts for instance from Jan - Nov to Feb-Dec. How can I
do that in a smart way, without editing each and every
chart? Using some kind of variable? Have anyone done such
a construction?
Regards
Anders

 

[Tushar Mehta]

You will have to make changes once to use named formulas in your
charts. Then, for subsequent months, you will be able to just select
the starting month.

On the Dynamic Charts page of my web site are 6 examples of how to
create charts that evolve over time. These examples also include how
to specify the starting point and/or select the number of charted data
points.

Do keep in mind that the web site examples all use column data, whereas
your data sets are in rows. You'll have to adjust the OFFSET formulas
appropriately.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions