Chart Labels

T

Troy

I have a range for the values from B7:B89 and when I chart
it, several blank spaces are shown on the Data labels on
the bottom. Reason for this is because in the range I have
blank spaces for future entries. This sheet is for a full
year so I need to have empty available entries.

Is there a way to not show 0 values in the chart?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
One extra x axis item that wont go away - can anyone help? 3
How to getting text labels to show up in scatter chart. 0
Drop down list control value in vba 2
Dynamic charts with named range Windows 8.1 0
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Creating a Chart on form from selected data in query. 0
Labeling on independently stacked line chart 0

Top