MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using a macro for creating a chart

Posted by Mike P. on February 05, 2002 12:28 PM

I've recorded a macro that will create a graph. However, when I recorded the macro, I used specific data. My problem is that this data will be added to on a weekly basis. How can I modify, or re-record my macro so that I can select/highlight the desired data, then run the macro to create the chart? Or, can the macro pause at the point where this data is needed? Thank you in advance for your help.

Posted by laura jean on February 05, 2002 3:02 PM

use the macro then edit the chart series

if you create the chart, then click on a series,
the range will appear as a box around your data
(as long as the data are in adjacent cells) which
you can edit.