chipshotThe More I Learn, The Less I Know
join:2001-11-07
Louisville, KY | reply to zach3
Re: [Excel] Formula Question Why aren't you just graphing what comes out of your pivot table? I don't understand why you're splitting the positives and negatives into separate columns. Graphing the positives and negatives as a single range usually makes the most sense.
If you're trying to get the negative bars to show up as different colors, there's a way to do that, but it's kind of complicated and it will make your spreadsheet much less intuitive to update.
--
Eschew obfuscation. |
|
|
|
zach3ZachPremium
join:2000-05-04
Saint Louis, MO | 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 |
|
