+ Reply to Thread
Results 1 to 3 of 3

How to Change View of WaterFall Chart?

Hybrid View

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    How to Change View of WaterFall Chart?

    Hi Chart experts,
    Following picture shows my question.
    http://i.cubeupload.com/9nNpV6.png

    So, this is current sort of chart axis.
    NET PROFIT
    TAX (-)
    EXTRAORDINARY COSTS (-)
    EXTRAORDINARY REVENUES
    FINANCING COSTS (-)
    ORDINARY COSTS (-)
    ORDINARY REVENUES
    OPERATING COSTS (-)
    COGS (-)
    DİSCOUNTS (-)
    GROSS SALES


    This is what I want sort of chart axis.
    GROSS SALES
    DİSCOUNTS (-)
    COGS (-)
    OPERATING COSTS (-)
    ORDINARY REVENUES
    ORDINARY COSTS (-)
    FINANCING COSTS (-)
    EXTRAORDINARY REVENUES
    EXTRAORDINARY COSTS (-)
    TAX (-)
    NET PROFIT


    Enclosed file for testing.
    Best regards...

    Note: Do not change data sort!
    Last edited by HerryMarkowitz; 09-01-2015 at 06:41 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,849

    Re: How to Change View of WaterFall Chart?

    Right click on Y axis
    Select "Format axis"
    In the format panel, select Axis options
    Check box for "Categories in reverse order"
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: How to Change View of WaterFall Chart?

    Hi 6StringJazzer,
    You are perfect!
    Thanks a lot.
    Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 AM
  2. Waterfall chart add-ins?
    By Miles in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-03-2013, 06:34 PM
  3. Waterfall Chart
    By FM1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-29-2013, 02:51 AM
  4. waterfall chart
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 02-19-2010, 12:50 PM
  5. Waterfall chart
    By wjviveen in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2009, 10:18 AM
  6. Macro to change the view of a pivot chart/table
    By svn_pie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2007, 04:53 PM
  7. waterfall chart ... once again ...
    By SIGE in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-30-2005, 11:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1