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

Rafav

New Member
Joined
Sep 2, 2014
Messages
1
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)
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,857
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top