Jump to content

Excel Charting Help


NukedWhale

Recommended Posts

Let's say I have a chart in Sheet1. It uses my data in Sheet1!A1:A10.

I want to create an identical chart in Sheet2, using the data in Sheet2. My data for Sheet2 is in Sheet2!A1:A10, the exact same row/column address as my first sheet. However, if I copy and paste my chart from Sheet1 into Sheet2, the new chart still refers to the information in Sheet1.

Is there anyway to make the data series in charts have relative sheet addresses and not fixed addresses?

If there isn't an Excel option, could I do it with some type of Visual Basic Loop? I.E. The loop looks at my charts in various worksheets, replaces old worksheet destination with the name of the worksheet in which it currently resides? I don't know much (anything) about visual basic so I'm grasping in the dark here.

Any help or directions would be helpful.

Thanks,

NukedWhale

Link to comment
Share on other sites


I found that if you copy a worksheet that contains a chart, the new worksheet's chart will use the new worksheet for the series formulas.

I created my desired chart format in one worksheet using a real dataset and then copied that worksheet and pasted the new source data over my old data.

I also found some information that could possibly be used for a VBA solution.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...