+ Reply to Thread
Results 1 to 3 of 3

Chart where data is above & below X axis but no negative value

  1. 08-16-2018, 11:53 AM #1
    adipa
    adipa is offline
    Registered User
    Join Date
    08-07-2018
    Location
    London
    MS-Off Ver
    Mac v16.53
    Posts
    25

    Chart where data is above & below X axis but no negative value

    Hi
    In the attached excel file I basically am looking to have 'Sold' (orange fill) above the X axis and 'Bought' (Blue fill) below the X axis.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-16-2018, 12:46 PM #2
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Chart where data is above & below X axis but no negative value

    Look at this solution. Value labels given from the cells next to the data.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-16-2018, 01:08 PM #3
    adipa
    adipa is offline
    Registered User
    Join Date
    08-07-2018
    Location
    London
    MS-Off Ver
    Mac v16.53
    Posts
    25

    Re: Chart where data is above & below X axis but no negative value

    Thats perfect

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Coloring negative positive numbers on Y axis in chart
    By ammartino44 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-20-2015, 09:35 AM
  2. negative y axis on pivot chart but axis doesn't change
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:19 PM
  3. Chart Axis Scale Editing - Positive and Negative Independantly
    By BIGGIE9 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-11-2013, 02:27 PM
  4. Custom number on Chart Axis - Shortening negative and postive numbers
    By hoffey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2009, 08:11 PM
  5. [SOLVED] Negative values in bar chart overlap axis labels.
    By Bonny in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-17-2006, 03:40 AM
  6. [SOLVED] negative [h]:mm:ss does not show on the x axis of a chart
    By Devo Clubber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-29-2006, 08:25 AM
  7. [SOLVED] How do I stop axis titles from overlapping with negative chart da.
    By KarenNeedsHelp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-15-2005, 12:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1