Using Name in Chart

[hsh982]

Hi
I need to know how to use a name in a chart. I have named a range of data as a specific name such as "Temp". and now I wanna refere the value range in chart (series) to this name. but not wroking
and idea would be appreciated.

 

[GlennUK]

Describe the contents of the range referenced by the name. Give the formula used for the name. Say what steps you took to try to use the name in the chart, and what actually happened.

 

[hsh982]

In the step we specify "Source data" in the "Series" tab I want to refere for "Values" instead of "='Daily Progress'!$C$27:$C$78" I want to put "ChartAct" which is exactly the name defined for the range "Daily Progress'!$C$27:$C$78".
When I put in "Values" box "=ChartAct" the line chart is disapears! I don't know how to say excel to understand this name is for the same range?!

 

[Trevor G]

When you get to the step of selecting the range via the wizard Press F3 this will give you the list of Named Ranges then select the name you want to use.

 

[GlennUK]

Instead of
"='Daily Progress'!$C$27:$C$78"
try
"='Daily Progress'!ChartAct"

 

[hsh982]

It worked very well.
But I have another question.
I want this name not to be fixed and be choosen by user. For example this name is in Cell B2. First user select name "ChartAct" and the chart is drawn. then User will select another name "ChartPlan" that refers to another range. it should draw another chart.
I want my Chart be dynamic by choosing any name in cell B2.
There is avalidation list in cell B2 contains all names.
any idea is appreciated.