Charts in Office 2007
 

I have create a chart selecting some cells in a sheet. I now want to create a
similar chart, pouring data from the same sets of cells, but in a different
sheet (exactly the same organization of data and cells).
Is there a simple and effective way to copy the chart and then modify the
data source manually? thru the new UI I find this almost impossible.

Thanks, Stefano

Charts in Office 2007
 

In article ,
says...
I have create a chart selecting some cells in a sheet. I now want to create a
similar chart, pouring data from the same sets of cells, but in a different
sheet (exactly the same organization of data and cells).
Is there a simple and effective way to copy the chart and then modify the
data source manually? thru the new UI I find this almost impossible.

Thanks, Stefano

Copy the chart to the other sheet or get it there however you want. Once
there, click the plotted series. In the formula bar you will see =SERIES
(...) In there, change the sheet reference as desired.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions