Dynamic Charts

[sharon]

I know how to make Dynamic charts but how do you adjust the data serie
automatically when new series data is added. For Example.

Old Data

chris 2
chris 5
sue 4
sue 3


New Data

chris 2
chris 5
chris 6
sue 4
sue 3

When new data is added to the bottom the chart adjusts but how do yo
get the series to adjust to the "chris" series which is in the middle?

 

[Tushar Mehta]

Using the technique based on the OFFSET function (examples are on the
Excel | Tutorials | 'Dynamic Charts' page of my web site), the plotted
data will adjust irrespective of where you add the data -- as long as
the range is contiguous.

--
Regards,

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