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.
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
RE: Much data to same chart format
See htt
Cheers.....
RE: Much data to same chart format
=[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
=====================================
Eng-tips forums: The best place on the web for engineering discussions.