Vba macro to update waterfall charts in excel 2016

[ANTONIO1981]

HI all

I Still don't know how to solve this

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
PLAN	198
Sites	(24)
Vol	88
RPW	(10)
Comm	(0)
VCPW	0
FCPS	(6)
OH	(1)
Other inc	(1)
TY	245
	245

<tbody>
</tbody>

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...cro-update-waterfall-charts-excel-2016-a.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.