×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Much data to same chart format

Much data to same chart format

Much data to same chart format

(OP)
I have lots of data sets from a data acquisition system that I would like to selectivly plot on a common chart format.

Each data set is an individual test run.  I can easily get the data into either individual workbooks, or onto separate worksheets.

Once I create a chart format that I am happy with using the first data set, is there an easy way to "drop" that chart format onto other sets to quickly generate the same chart?

The best I can figure out is to save my first chart and its associated worksheet as a "template", and cut and paste data onto copies of that template.  Seems like there should be a better way.

RE: Much data to same chart format

When I have to do what you are describing, I get the first chart the way I want it, then I create copies of the chart.  I then go in and change the source data references to the new data.  It helps to have the data on different worksheets but with very similar names, like "Source Data 1", Source Data 2", etc.  Then changing the reference is as simple as changing one number. Of course, the data need to be in the same rows and columns on the different sheets.

RE: Much data to same chart format

I did that once a long time ago.  I know that I named all my data ranges.  I set up a chart file whose series were named ranges in the other file
=[File1.xls]Sheet1!Datarangename

Then set up other excel files with data and same named ranges.

To change which file the chart links to, use Edit/Links, select an existing linked file and then "change source" to substitute a different file.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Much data to same chart format

I had the datarangename labels on the top of each column.  Everytime I added data to the bottom I would select the block of data and Insert/Name/Create/Top-row to update the range definition (otherwise the new data won't show up in the chart). There may be easier ways to do it with dynanmic ranges but that's the way I did it.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources