Dear Excel Community,
I have an excel bar chart (please see attached) that has 4 categories (boy, girl, different word, prefer not to answer), listed in Column B. Column C indicates their sample size, and column D indicates their scores. However, I wrote a formula in Column D (not shown in the datasheet) to only display the scores if N size in Column C is greater than 10. The bar chart then displays the scores of the categories accordingly, i.e., display the scores for those categories of N size greater than 10, with score values placed right next to the bars.
My head scratching problem is that for the bars that are not displayed, there's a "0.0" that seem to serve as a placeholder for them instead. How do I get rid of these 0.0s? I tried to manually delete these 0.0s but what happens is that the next time I enter a dataset where the N sizes are greater than 10 for the last 2 categories, the values for the scores next to the bars are not displayed. How do get rid of the 0.0s so that when new datasets are selected, the bars would just show up with scores for N sizes greater than 10, and not show up at all (and without the 0.0s) ? I went into Format Data Labels and Format Data Series and messed with the settings, but nothing seemed to work.
I hope someone can provide me some assistance to this problem. I have lots of charts like this, but if you show me how to do this with one chart, I can replicate the process with the rest of the bar charts. I may have to edit each chart individually so any advice on the shortcuts would be immensely appreciated.
Thank you so much for your time and valuable feedback, as always!
Anita
Bookmarks