Macro to Update Chart

D

ddng

I have data that I want to draw a line chart too. When I change the
data I want to see the changes in the chart. Can some one point me in
the right direction of simple charting and macro's?
 
T

Tushar Mehta

Select the data range then click the ChartWizard button on the toolbar.
Follow directions to create the kind of chart you want.

When you change the data in the range you plotted, the chart will
automatically update.

--
Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2
Embed the same Excel multiple times 0
Cannot see and gantt charts or other displays 0
Changing defauls in 2019 0
Can't format 'invert if negative' colour programmitically (macroignores it!) 0

Top