thanks a lot, avinash! :)
On Aug 30, 7:03 pm, "avinash verma" <[EMAIL PROTECTED]> wrote:
> Below is a smaple snippet that shows how to use
>
> -- to select the properties
> For Each chrt in ActiveSheet.ChartObjects
> chrtName = chrt..Parent.Name ' chrt name
> if chrtName = "Chart1" the
Just press CTRL and click on the chart, you will be able to see the
chart name in the name box on the top left corner..
Regards
On Aug 29, 4:24 pm, XpandeR <[EMAIL PROTECTED]> wrote:
> Hi Folks,
>
> I'm working on a macro that generates a chart on the basis of just
> refreshed table. But as
Below is a smaple snippet that shows how to use
-- to select the properties
For Each chrt in ActiveSheet.ChartObjects
chrtName = chrt..Parent.Name ' chrt name
if chrtName = "Chart1" then
chrt.delete
end if
Next
--- to set other properties
With ActiveSheet.ChartObject
