Best Pratice :: Named Ranges

[binaryfingers]

Hi
I am hoping you can help advise on a best pratice solution with named ranges.

I have 5 sheets that are all formatted in the same style.

On each sheet I have a chart that I am using named ranges on.

the coding is as follows:

chart1Forecast
=OFFSET('GameStation Sales Report Jan06-Dec06.xls'!chart1XValues,4,0)

chart1Range
=OFFSET('sheet 1'!$BC$154,0,0,1,COUNTA('sheet 1'!$154:$154))

chart1Values
=OFFSET('gs sales.xls'!chart1XValues,3,0)

chart1XValues
=OFFSET('sheet 1'!$BC$154,0,MATCH(Summary!$C$1,'gs sales.xls'!chart1Range,0)-1,1,13)

I then call forecast and values as data series and xvalues as x axis data.

What I would like to do is repeat this for 5 charts each per sheet (sheet 1 to sheet 5) (so each sheet has 5 charts)

Using named ranges, local or global...is there a best pratice way of achieving this?

Eg, utilise Chart1 on sheet 1, sheet 2, sheet 3, sheet 4 and sheet 5 as all the data is in the same style, just reflecting the different sales/values. this way I will only have to create 5 sets of chart named ranges instead of 25?

Hope you can help..

Thanks

 

[Gavona]

If you can I would avoid local named ranges - they can be tedious in several ways - most especially when sorting bugs. I suggest a simple naming convention.

However, I would not presume to define best practice!

I do wonder if all your data could more conveniently be on one sheet, in a single database and extracted using Pivot Charts:
Page fields to enable you to select the data for that particular chart.
There is an option to "Show data table" if that is a requirement.


Gavin