How to remove gaps and #NA from bar chart

[Kiran2012]

Hi,

I have created a dynamic chart based on checkbox selection. I am using NA() instead of "" in the if function. The problem here is with the chart. It displays the #NA. Also in my data range, if the last/third section is used in the chart (based on 3rd checkbox), the chart shows all the #NA in the start with a gap and column bars showed in the last part of chart.

How to remove the gaps and #NA and show only the column bars?

I've googled, but didnt find a solution. Tried changing to zero and then custom number format. but the #NA is not going nor the gap. Pl help

 

[Asheesh]

First of all, welcome to the forum...

Do you mind posting a sample file..it will help members to help you

 

[Somendra Misra]

Hi Kiran,

Go through below link which deals with drop down & check box to create dynamic chart.

http://chandoo.org/forum/threads/dynamic-charts-with-dropdown-list-check-box.20595/

Regards,

 

[Kiran2012]

Hi Asheesh & SM,

Thanks for looking into this. Attached is a sample file. Chart should come in the first sheet. Now the chart is in second sheet. If you see, the chart is showing #NA for the items which are not checked via checkbox in first sheet. I need to show the status (completed/not completed) for all the vertical for the selected one.
Expecting an early reply... Thanks in advance

 

[Somendra Misra]

See if this file helps.

Regards,

 

[Kiran2012]

Hey SM,

Thanks a ton... works like a charm

 

[Somendra Misra]

You are Welcome!!!

Regards,

 

[Kiran2012]

btw, how to change the profile photo?

 

[Somendra Misra]

Go to your profile page and click on your photo it will give you options.

Regards,