Named Ranges in Chart Not Working

[shelby55]

Hello

I'm using Excel 2003.

I have graph using a named range as the sources. When I select on source data, specific series and the values I see the range the chart is using as the source and it's reflecting one range (B10 to B30).

However when I select the Name menu, define and select that same named range, it shows me B9 to B29 which is what I want. Why would the results differ? How can I correct?

Thanks very much.

 

[xlbo]

Are the ranges statis or dynamic (ie are they hard coded or set as the result of a formula)?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

In the char source data, you should see the range initially like this
[tt]
Sheet1!B10:B30
[/tt]
If your corresponding named range is Shelly, then your chart source data ought to be changed to ...
[tt]
Sheet1!Shelly
[/tt]
you must retain the sheet reference.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi

Thanks Geoff and Skip....it was a dynamic series and the range was initially referencing one source and I changed it. I think it's because I copied the original worksheet and created a new one where I made changes and used that as the new source.

The series indicated it was from the new source, all things pointed to it being from the new source but it wasn't working.

So I instead copied the cells of the worksheet and pasted into a new one instead of using worksheet copy. Then I changed the named ranges to the new sheet and all is well.

Not sure what the original problem was but it's fixed now. Thanks for your responses.

 

[xlbo]

When you copy worksheets with range names on them, excel can get a bit confused and normally ends up creating 2 ranges for each name - one specific to each sheet. Can normally tell if this has happened as there is a "sheet" reference in the name list box - if you delete one, the other is still there.....I know you've fixed for now but might be worth remembering as something to check for the future...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question