Excel Charts: Pulling Defined Name from Cell (using Indirect?)

[Rafav]

Hi there,

I have built a dynamic Excel Chart, a scatter plot that takes Series X values and Series Y values from two defined named ranges, NameA and NameB (which are dynamic as the name is given using offset and counta).

At the moment, however I have typed the defined name ranges manually into the chart (under Select Data), so the chart knows that it takes NameA for the X-axis and NameB for the Y-axis. However, I want to have NameA in cell A1 and NameB in cell A2 and have the chart take the names of the ranges from there.

Is it possible to do this?

My goal being that I can then type quickly NameC in cell A1 for example (NameC being another metric of the same data series) and the chart changing plotting NameC on the X-axis and NameB on the Y-axis.

Thanks for your help.
Max

P.S Other Suggestions welcome. I need to built a tool where one can select metrices to be used for a chart freely (and the chart should be dynamic, so that new data points can easily be added)

 

[pgc01]

Hi Max
Welcome to the board

Define a name that evaluates the named range whose name is in the cell.

For ex.,

Define: rYValues

Refers to: =EVALUATE(Sheet1!$A$2)


You use rYValues for the Y values of the chart.

Now you can write NameB in A2 and the chart will use for the Y values the NameB range.