Results 1 to 2 of 2

Vba macro to update waterfall charts in excel 2016

This is a discussion on Vba macro to update waterfall charts in excel 2016 within the Excel Questions forums, part of the Question Forums category; HI all I Still don't know how to solve this I have the following bridge, I'm using the new feature ...

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    95

    Default Vba macro to update waterfall charts in excel 2016

    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

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    39,186

    Default Re: Vba macro to update waterfall charts in excel 2016

    Duplicate: https://www.mrexcel.com/forum/excel-...el-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.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com