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. T
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.
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
Best Answer
Assuming you're using Excel 2010 (and probably 2007), the following should help:
You can really speed up modifying charts by using named ranges for your data, instead of direct cell references (plus it makes them much easier to read). Also, if you select a chart series, it's formula will display in Excel's formula bar. There you can directly enter new information to modify the series without having to open the Select Data dialog box everytime. That is especially handy with named ranges.