• 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 Legend that will not be shown for a Single line of #N/A

S

seanteo

New Member
I have a variable line graph with Legend. Its reading from H11:S16 (12 months data).

For H16:S16, this row's data might varies. A radio button is available to select either Product A or Product B.


I have no problem to read and display the Product A data as it will show all 6 lines of data. But when I select Product B, it will be 1 line lesser than Product A.


When selecting Product B, my graph is showing a "na" in the legend. How can I / How do I need to not display the "na" when I select on Product B ?
 
I can't actually. Am in the office and need to apply their rules. Its all blocked.


For the legend:


If I choose product A at the radio button, the legend for the last row (H16:S16) will be called Total Product A (with orange line).


If i choose product B at the radio button, the legend for the last row (H16:S16 - will be reading blank) will be shown as na (with orange line).
 
Hi, MiceBody!

This didn't help?

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

http://chandoo.org/wp/tag/dynamic-named-ranges/

Regards!
 
Unfortunately, the chart legend likes to always display all the relevant series. Admittedly, I can't access files from my location (sounds like we have similar work policies) but can you try removing the legend and instead using a series label on the last data point to show the series name? The advantages would be that it's slightly easier for readers to associate the name with series, and if one series isn't being displayed, the series label will also not be displayed.
 
Hi, MiceBody!

The zip file of the provided link to your SkyDrive is password protected and the password isn't that which you posted. Despite of this if I were you I'd follow the workaround described by Luke M.

Regards!
 
Hi SirJB7, the password above is valid in my PC, not sure why.

Can we use offset ?

The series label would not be good enough in my chart as the volumes might varies from thousands to few hundred thousands. The lines are just too near.

Any otherway that I can share my file?
 
Can you upload the workbook via any of the services described here?

http://chandoo.org/forums/topic/posting-a-sample-workbook


I still don't think you'll be able to hide the legend series through workbook functions. You might be able to do it via VBA, but then you'd need someway to detect which series are hidden/unused.
 
Hi, Micebody!

Regarding the password issue that works in your PC, did you try to download a copy of the uploaded mail, send to yourself by mail, and download an open in other machine not connected to the corporate network?

Regards!
 
You must log in or register to reply here.
Back
Top