Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding 0 value data labels in chart
I have an Excel column chart with data labels that show values which
are numbers between 1.0 and 5.0 (rounded to one decimal point). There are a number of blank values in the data table used to produce the chart, and they are being charted as "0.0". Apart from the fact that this is ugly, it doesn't really even make sense with this data. So how can I keep the desired data labels (1.0 - 5.0) and hide the 0.0s? It's been suggested to me that I could force #N/As and then Excel wouldn't graph those values. But when I try that, I either end up with stubborn 0.0s or, worse yet, data labels that say "#N/A". Is there VBA solution here? A way to loop through the labels and hide the values, maybe? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Data labels in Chart | New Users to Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Data Labels in a Chart | Excel Programming |