zach3ZachPremium
join:2000-05-04
Saint Louis, MO | reply to chipshot
Re: [Excel] Formula Question Chipshot,
Yes, I am wanting the bars to be different colors that I why I choose this method to make the chart. You are very correct it is an involved process because in my final chart format the chart is dynamic.
Thanks,
Zach |
|
|
|
| oops
In the chart
Click on one of the values (4170)to highlight the data series labels
Menu Bar > Format > Selected Data Labels
Number Tab > Category > select Custom
enter in Type: #;-#;""
This formats the chart label not to display zero values
For more info, see "Create or delete a custom number format" in Help |
|
zach3ZachPremium
join:2000-05-04
Saint Louis, MO | xlhth,
Works like a champ!! 
Thanks,
Zach |
|
