Quarterly Data Charted to Standard Line Graph

**RileyBear** · 10-07-2008, 05:23 PM

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...

**Andy Pope** · 10-08-2008, 05:05 AM

To chart the last N periods will require using named ranges.
The dynamic colouring of a period would require extra data series or vba code.

If you need more help can you post an example workbook and chart.

**RileyBear** · 10-08-2008, 10:05 AM

I do require additional help with this problem. Please see the attached spreadsheet. You'll notice that each quarter I post the data in a new column but I have to manually manipulate the series strings to just display the last 4 quarters worth of data for trending analysis. Please advise. Thank You

RileyBear