Chart Relative To Worksheet When Copying- Excel 2007


G

Grace

I'm looking for a technique to make charts automatically reference data on
the current worksheet when I copy a worksheet containing a chart. In Excel
2007, the chart references the cells from the original worksheet while Excel
2003 would automatically update the reference. I can manually key in the new
worksheet as the reference but this is tedious.

any suggestions?
 
Ad

Advertisements

H

Héctor Miguel

hi, Grace !
I'm looking for a technique to make charts automatically reference data on the current worksheet
when I copy a worksheet containing a chart.
In Excel 2007, the chart references the cells from the original worksheet
while Excel 2003 would automatically update the reference.
I can manually key in the new worksheet as the reference but this is tedious.

any suggestions?

I couldn't repro (xl-2007) copying ws w/embedded chart, source data remains referencing to original ws (?)
(copied ws automatically updates the embedded chart source data to it's "new" location/ws)

perhaps with a little help from vba (?) i.e.

With ActiveSheet
.ChartObjects(1).Chart.SetSourceData _
Source:=.Range("a1:b1,a3:b5,a7:b9,a11:b13,a15:b17"), PlotBy:=xlByColumns
End With

hth,
hector.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top