Easily Plotting Multiple Data Series in Excel

Posted by John on Super User See other posts from Super User or by John
Published on 2012-06-25T15:03:50Z Indexed on 2012/06/25 15:18 UTC
Read the original article Hit count: 117

Filed under:
|
|
|

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. Each of these variables is going to be its own graph with devices being the series. My x-axis is going to be the dates that these values were taken. The problem is that it takes ages to do this for each spreadsheet since I have monthly dates from 1950 up to the present and I have about 50 devices in each spreadsheet. I also have graphs for calculated values that are in columns next to them. Each of these devices is going to become a data series in the graph. E.g. In one of my graphs I have all the pressures from the devices and each of the data series' names is the name of the device. I want a fast way to do this. Doing this manually is taking a very long time. Please help! Is there any easier way to do this? It is consistent and the dates all line up. I am just repeating the same clicks over and over again

Thank you!

© Super User or respective owner

Related posts about microsoft-excel

Related posts about graphs