Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Vba macro to update waterfall charts in excel 2016

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    143
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    0 0
     

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    40,029
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    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!"
    0 0
     

User Tag List

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
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com