+ Reply to Thread
Results 1 to 3 of 3

Delete one data point / value on axis

  1. 03-12-2019, 12:21 PM #1
    Angel403
    Angel403 is offline
    Registered User
    Join Date
    03-11-2019
    Location
    Canada
    MS-Off Ver
    Professional Plus 2016
    Posts
    4

    Delete one data point / value on axis

    Hi, is it possible to delete one data point/value (namely the negative value) from the y axis? If not, can it be hidden? Thanks!
    Reply With QuoteRegister To Reply
  2. 03-12-2019, 12:25 PM #2
    Angel403
    Angel403 is offline
    Registered User
    Join Date
    03-11-2019
    Location
    Canada
    MS-Off Ver
    Professional Plus 2016
    Posts
    4

    Re: Delete one data point / value on axis

    Scratch that, I changed the colour of negative values to white
    Reply With QuoteRegister To Reply
  3. 03-13-2019, 04:26 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,428

    Re: Delete one data point / value on axis

    You could set the Minimum Y axis to 0.
    Cheers
    Andy
    www.andypope.info
    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] X-axis of scatter chart: Tick mark and X-axis label for every data point
    By JayUSA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2018, 02:38 PM
  2. Chart Data skewed by one point along x-axis
    By phbryan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-13-2015, 06:23 PM
  3. Align last data point to Secondary axis (i.e. on the right) Should be simple!
    By Crawfinator1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-15-2013, 04:24 AM
  4. Charts: Only showing axis point with corresponding data
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2013, 07:58 PM
  5. Excel 2007 : Horizontal Axis Label - Last Data Point
    By bignowa in forum Excel General
    Replies: 1
    Last Post: 07-02-2010, 09:53 AM
  6. X Axis Labels every 96th Data Point
    By JonMulder in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-29-2005, 11:05 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