Hello everybody,

I am receiving many single sheet workbooks that contain a simple chart. These charts are produced by other people, have poor formatting and size. I have a macro that will resize the chart, and change the ChartStyle etc... BUT, only works if the Chart is "Chart1".

My questions is, how can I have my macro activate the chart on a worksheet without knowing the Index# or the name?