Update Chart Macro

S

Sal

Hi,

I have a workbook that contains a summary sheet (based on a 3d formula)
from which I create 2 charts. Can anyone suggest a macro so my user can
press a button and a macro runs to detect any new worksheets that have been
added, add this new sheet to the 3d formula in the summary sheet and the
associated graphs are updated?

Many thanks
 

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

Need Help with Macro Security 1
Dynamic Chart Title With 3D Stacked Column Chart 2
Excel 2003 dynamic named range for the values in a pie chart 1
Update a chart using Hyperlinks 4
One extra x axis item that wont go away - can anyone help? 3
Displaying Data grabbed using concatenates and CountIfs 1
Cannot change data source for copied charts 1
copy chart between multiple sheets in workbook 4

Top