Named Ranges

timfouts

New Member
Joined
Mar 16, 2011
Messages
2
Hello - I have a workbook with 2 sheets...one sheet is interactive charts and the other sheet is the data. I have alot of named ranges going on to support the charts.

Here is my problem...I need to create 2 more sheets within the same workbook to support a different set of data but same format. I copied the 2 sheets over within the workbook and the named ranges came along with it, which is what I needed...but I need the named ranges to work with the 2 new sheets within the workbook. When I did this none of my charts would work, anyone have any ideas? I dont want to create all the named ranges again for these 2 other sheets. Thanks
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
I don't believe its possible for data in three sheets to have the same name. To be different data, it must have a different name.

You can set sheet-level names by adding a sheet identifier:

ChartData <-- a global name (workbook level)
Sheet1!ChartData <-- a local name (worksheet level)
Sheet2!ChartData <-- another local name (worksheet level)

HTH,
ξ
 
Upvote 0
Those named ranges, were they globally defined? If so, they are now duplicated as local names for each sheet you copied. If you are using the range names in the series formula of the chart, prepend them with the sheetname, like so:

'Sheet Name'!RangeName

To use the global range name in the SERIES formula, the syntax is like:

'Workbook name.xlsm'!RangeName
 
Upvote 0

Forum statistics

Threads
1,222,310
Messages
6,165,261
Members
451,949
Latest member
bovacik

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