Dynamic Charts

  • Thread starter Thread starter sharon
  • Start date Start date
S

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?
 
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
 
Back
Top