Charts: Distinguishing 0 value from no data in a chart

  • :spin:
    Can someone please help me ove this hurdle?
    I am charting datain a bar graph where some data is 0% and other places it is No data. I need to distinguish betweenthe two of these in my chart.
    The chart does not plot anything if there is 0% or if there is no data to chart.
    HELP! :spin:

  • Hi wmorgan and welcome,


    Indeed, a zero and no value bar have the same visual appearance.


    You could display datalabels, in which case the zero will be shown as 0% and the no value will not have a data label.


    How would you like to illustrate the difference in your chart?


    Cheers
    Andy

  • V. Nice Andy. I was going to suggest Rob Bovey's Chart Labeller, but you beat me to it!


    Should this be in FAQs or That's Cool as well?


    Rgds


    Chris

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!