 zach3 Zach Premium join:2000-05-04 Saint Louis, MO clubs: | 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 |
|
  xlhth
@optonline.net
| 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 |
|
 zach3 Zach Premium join:2000-05-04 Saint Louis, MO clubs: | xlhth,
Works like a champ!! 
Thanks,
Zach |
|