Using a Named Range in a Chart

RaviWildcat

Board Regular
Joined
Jun 18, 2010
Messages
97
Hi Everyone,

I'm trying to embed a named range in a radar chart.

The Chart Data Range is ='Raw Data'!$D$32:$X$33,'Raw Data'!$D$36:$X$36

The Name is ='Raw Data'!$D$36

Y Values are ='Raw Data'!$E$36:$X$36

Horizontal Axis labels are ='Raw Data'!$E$32:$X$33

I've got a Named Range called 'tech_lead': ='Raw Data'!$D$36:$X$36

Question:

1. When I try specifying '=tech_lead' in the Y values I get an error message (there's an error in the formula you entered) .

2. I also tried putting the value ='Raw Data'!$D$36:$X$36 in the cell 'Raw Data'!$S:$35 and then selecting the Y Value as offset (Raw Data'!$S:$35) but that didn't work either?

Any suggestions?

Thanks!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,968
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
You need to reference the worksheet that contains the Name. tech_lead doesn't work, but try 'Raw Data'!tech_lead.

But...

You can only specify names in the name, X values, and Y values of an individual series. If you enter a name into the larger chart data range box, it might accept it, but it will convert it to its cell address, so it will no longer be dynamic.

Here's a very old tutorial that might help: Dynamic Chart Source Data
 

Forum statistics

Threads
1,144,369
Messages
5,723,945
Members
422,527
Latest member
TotalBeginner201

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
Top