Vba macro to update waterfall charts in excel 2016

ANTONIO1981

Board Regular
Joined
Apr 21, 2014
Messages
162
HI all

I have the following bridge, I'm using the new feature in excel 2016 to create a waterfall chart.

the bar for PLAN must in color X
the bar for TY must be in color Y
the rest of the bars for the bridge red for negative values, green for positive values

At the moment i have to manually change all colors each time that the numbers update

is there a code to do it or if you can refer me to other website to learn how to do it

it is so annoying! :) many thanks!





BRIDGE
TY v PLAN
MONTH
PLAN198
Sites(24)
Vol88
RPW(10)
Comm(0)
VCPW0
FCPS(6)
OH(1)
Other inc(1)
TY 245
245

<tbody>
</tbody>
 
Last edited:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,215,394
Messages
6,124,683
Members
449,180
Latest member
kfhw720

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top