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