Updating a chart, within a workspace

  • Thread starter Thread starter Andrew Singer
  • Start date Start date
A

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]
 
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/)

Andrew said:
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]
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top