Hi everyone,
Within a worksheet there are 2 embedded charts. one of these is visible the other is not. Using Vb, how can i identify the name of the chart which is visible ? and can I modify the chart (i.e. change the chart type) without activating it ?
Any help would be greatly appreciated.
Within a worksheet there are 2 embedded charts. one of these is visible the other is not. Using Vb, how can i identify the name of the chart which is visible ? and can I modify the chart (i.e. change the chart type) without activating it ?
Any help would be greatly appreciated.