Can the name of a series data for a chart be changed more easily?

**billj** · 09-19-2013, 11:39 AM

Hello, I just got a question about how to easily change the name of a series data for my chart.

If I click the line of the line chart, it shows the function as: =SERIES("P/E Trailing",'PE Analysis.xls'!DateRangeRP,'PE Analysis.xls'!PEtrl1000Chart,1).

Here, PEtrl1000Chart is the name of a named range. I need to plot 1 chart for each of the 100 named ranges (100 charts!). The 100 named ranges is like PEtrlxxxxChart. Here, xxxx is the contents that need to be changed. I can change xxxx manually, but this will take much manual work. Is there a way that the xxxx can be replaced based on the text value of cell A1? So if I input 1000 in cell A1, then the chart will be automatically updated.

Thanks a lot for help.

**billj** · 09-19-2013, 12:37 PM

**billj** · 09-20-2013, 06:51 AM

**Andy Pope** · 09-20-2013, 07:14 AM

it's not clear to mean whether you want to update a 100 charts or have 1 chart that will display 1 of 100 named ranges.

**billj** · 09-24-2013, 07:56 AM

Hi Andy, I just need a single chart to display ONLY ONE of the named ranges.

**Andy Pope** · 09-24-2013, 08:02 AM

You can use another named range that uses the INDIRECT function to reference required named range.

In this simple example DATA01, DATA02 and DATA03 are named ranges. The chart uses USEDATA which is named range using INDIRECT.

Change G2 to update chart