Excel. Help With Chart Not Showing Zero Values

[aedctalk]

Hello. I'm making a chart for values of L6:L40 which are all percentages.

The chart is a bar graph..

On C6:C40 i have movie titles. (the amount which vary by week.

ON MY CHART.. i always have at the bottom a bunch of bars that just show 0.00%

How can i get the bar graph to only recognize values either where..

values are greater than zero in the l column rows.. or value is not equal to "" null in the c column?

Is this possible?

 

[kazbah]

I just used the if function using the if(test, value if true, NA()) format to create a row of numbers in which the 0 or empty values should have been #N/A, and in fact were, but when I created a line graph, the 0s were still included.

 

[Paul van Kampen]

Hi,

I came across this thread looking for an answer for the same problem, but found a solution that worked for me, hopefully it will work for others as well. I just formatted my chart (bar graph) to start at 0.001 by right clicking on the axis, formatting the axis, and starting it at the minimum of 0.001, and any data labels indicating 0 disappeared. Of course, you want to axis to show whole numbers, and so it will just start at 0 when rounded.