• 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.

Interactive Sales Chart using MS Excel

D

dgabis

New Member
Hi Chandoo, GREAT graph and great site!!!! I have a question on the data labels. When data label is added in the chart and we select a “year” and then if we choose a “region” #N/A’s appear and data labels disappear. Any thoughts on this? Thanks and hugs from Argentina.
 
Hi ,


A column or bar chart does not need NA() to not plot values , since you will not see 0 length bars or columns.


Change the formulae , and put the proper formatting for the data labels.


Check the file here :


https://www.dropbox.com/s/lvoj6bbix9he4wf/interactive-sales-chart.xlsm


Narayan
 
@dgabis

Hi!

Remember this?

http://chandoo.org/forums/topic/option-button#post-71495

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