My delima: I generate a line chart that shows the DC voltage of 30 batteries, with DC voltage readings taken once per Quarter for each battery. Each Quarters readings are placed in a separate column on the spreadsheet with the date taken on top. I now create a line chart by selecting Source Data and the Series String with the NAME being the Date. I repeat this process for each of the 4 quarters of data using different colors to identify different quarters data. Works great. The problem is that in the 5th quarter I add another column of data. How do I get the chart to automatically display the last 4 quarters of readings without manually selecting the Source Data and Series for the new column while REMOVING the 1st Quarters string from the Chart. I would like to find a way to automate this process. Also I always show the most recent Quarters data in the Chart with a "RED" color. I have to manually change this every time also. Is there anyway to automate this process? Thanks...
Bookmarks