Plotting Multiple Sets of Values Having Different X Axes in Excel
Plotting Multiple Sets of Values Having Different X Axes in Excel
(OP)
Does anyone know how to plot multiple sets of data in Excel that have different X axes. I have data versus time from flight measurements as well as predictions from a simulation code and I want to present them on the same plot. The problem is that the X axes (sample rate for flight data and print interval for code) are different. Any suggestions? Changing the code's print interval to match the measurements would be time-consuming as I'm dealing with a couple of thousand seconds of flight time. Thanks.
RE: Plotting Multiple Sets of Values Having Different X Axes in Excel
RE: Plotting Multiple Sets of Values Having Different X Axes in Excel
1) Put all your x-values for data in a single column.(ie. Data set 1 followed by data set 2,..etc.)
2) Create a seperate columns for each data set's y-values.
3) Fill the y-values in data set 1 with zero's in data set 2, 3 ...etc. (y-values for data set 2 get zero's oposite data set 1, data set 3...etc)
4) Now plot x-y scatter charts using the entire columns for each graph line. You will find excel will now chart exactly what you are after.
Hope you can decipher my example....
Remember...
"If you don't use your head,
your going to have to use your feet."
RE: Plotting Multiple Sets of Values Having Different X Axes in Excel
RE: Plotting Multiple Sets of Values Having Different X Axes in Excel
It wasn't too many releases ago that at least one set of values had to remain constant. That's how i'd do it now, but looking at your question brought back some of the major headaches I encountered when i started using Excel.
Remember...
"If you don't use your head,
your going to have to use your feet."