Updating a chart, within a workspace

[Andrew Singer]

I keep a daily log of a particular price, plus its moving
average. I use an Excel spreadsheet for this. Under a
separate tab, I have set up a Chart, that visually tracks
both the daily log of price, and the moving average.

I need a simple method for updating the chart. So far,
the only method I can find that works is to "Clear"
[delete] each plot on the chart, and then use "Copy,
Paste" to achieve an updated Chart plot of the two
parameters. This is laborious, since I have to re-do my
color and line preferences each time. There must surely
be a more elegant method?

Thanking you in advance for any help you can give on this.

Regards,

Andrew Singer

[Cambridge, England]

 

[Andy Pope]

Hi Andrew,

You need to use Named ranges to make the chart update dynamically.

Take a look at Jon Peltiers examples.
(http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html)

or the dynamic charts on Tushar Mehta's site.
(http://www.tushar-mehta.com/)

I keep a daily log of a particular price, plus its moving
average. I use an Excel spreadsheet for this. Under a
separate tab, I have set up a Chart, that visually tracks
both the daily log of price, and the moving average.

I need a simple method for updating the chart. So far,
the only method I can find that works is to "Clear"
[delete] each plot on the chart, and then use "Copy,
Paste" to achieve an updated Chart plot of the two
parameters. This is laborious, since I have to re-do my
color and line preferences each time. There must surely
be a more elegant method?

Thanking you in advance for any help you can give on this.

Regards,

Andrew Singer

[Cambridge, England]

--

Cheers
Andy

http://www.andypope.info