# Stacked Cluster Column: Turn negative values red

#### CHBC1

##### New Member

Hi All,

In short: I am wondering if there is a reasonably quick way I can make the negative values (with the dashed borders) RED so they stand out more. It seems like I can either change all of them or none of them. I think I can also go in and manually change each one. The problem is that I'm creating 6-7 of these graphs, so it would take a considerable amount of time to go through one by one.

I understand this level of customization may not yet be available in Excel graphs, but I figured I might as well throw the question out there!

Thanks!

PS. If anyone is curious on what I'm doing..I am analyzing a new cost structure for a family of mutual funds and this chart is showing the impacts of the proposed fee structure (some funds will be slightly more expensive, some less).

Last edited:

#### elmer007

##### Active Member
I haven't done it with stacked bars before, but the way that I color positive and negative bars (green and red for my reports) is to have more than one bar setup so that:
The data range for the green series uses IF formulas to determine if it should contain a value or 0. This series is colored green (and will only show if there is a positive value as a result of the IF formula).
The data range for the red series uses IF formulas to determine if it should contain a negative value or 0. This series is colored red.

The result is that there are actually two series charted for every timeframe, but only one will ever show up due to the formulas in the data ranges; something like: =IF(B1>0,B1,0) for the green row and =IF(B1<0,B1,0) for the red row.

Example data ranges as a result of these formulas:
 Actual Data: 5 6 -3 1 -2 2 -8 5 Positive Row: 5 6 0 1 0 2 0 5 Negative Row: 0 0 -3 0 -2 0 -8 0

<tbody>
</tbody><colgroup><col><col span="8"></colgroup>

So the positive row only shows positive values or 0s, and the negative row only shows negative values or 0s. As data ranges, this results in a green series that shows 5, 6, 0 (doesn't show at all), 1, etc., and the same for the red series.

1,081,458
Messages
5,358,808
Members
400,513
Latest member
sdrowsick

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...