• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart does not update when named range changes?

R

rcreek09

New Member
Here's what I'm entering in my Select Data Source, Chart Data Range dialog box:


='Subtotals Paste Here'!District1

District1 is a named range that I adjust manually as needed.


XL appears to accept it, but then when I go back to the chart, it has changed to this:


='Subtotals Paste Here'!$D$14:$E$22


Which means I still have to manually update the range in the graph and completely defeats the purpose of using the named range.


What am I doing wrong?

Excel 2010, Windows 7.


Thanks!

Deb
 
Deb

Do you want to send the file to me

click on Excel Ninja

email is at bottom of Page
 
Was a solution ever found? I have the exact same problem. I've tried a lot of work arounds with a dynamic chart with changing # of series, but if I can get this to work, data labels will be usable.


My other attempts use a larger range, but populate a lot of 0 or "$" data labels, and blank items in the legend or "#N/A" which I tried as well. Let me know if you found anything useful, thanks!
 
Yes,

Deb's series range is ='Subtotals Paste Here'!$D$14:$E$22

it should have been ='Subtotals Paste Here'!$D$14:$D$22 etc
 
I know you can use named ranges in a series, but I thought Deb was trying to get the whole data range as a dynamic range. I was trying to get this working because sometimes there are 2 series, sometimes 4 or 5. When I'm showing 2 series, all the data labels and legend show a lot of blanks due to the larger range...


-I may have to use the camera trick that uses a named range that switch between ranges that contain the charts. I don't like using the linked pictures because the quality is always a bit lower and making all those charts will take up extra memory.


Any other suggestions?
 
I managed...


-Formatted data labels to hide 0 values

-removed legend

-made 5 legends in cells, saved them as ranges, and used the linked picture tool to cycle through legends according to the controls on the sheet.


Why is excel such a pain with legends...I can't reorder the items, hardly any options to format items, and just no flexibility.
 
You must log in or register to reply here.
Back
Top