Excel Charts

[Garlow]

I need to update several charts every day with new data added to a table. Is
there a quick way to update each series? Some Charts have 6 series and the x
axis is the dates, so these need to update also. Right now I type in the new
cell numbers everyday.
Day 1 would be c27:c40 tomorrow would be c28:c41 etc.....

 

[carlo]

Did you try to apply dynamic ranges?

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=518

hth
Carlo

 

[Jon Peltier]

Here is an example of dynamic ranges that follow the last 12 values (months)
in a larger range:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

You can adjust it for the last 14 values (two weeks).


If it's too much work to retroactively set up the dynamic chart series data
ranges, you could try this utility:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

You'd have to do it in two steps, once to change all chart data references
in the worksheet from 27 to 28, then to change all references from 40 to 41.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



Did you try to apply dynamic ranges?

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=518

hth
Carlo