+ Reply to Thread
Results 1 to 2 of 2

Scatter Chart Without a Vertical / Y Axis

  1. #1
    Registered User
    Join Date
    06-10-2017
    Location
    Buffalo
    MS-Off Ver
    2010
    Posts
    1

    Scatter Chart Without a Vertical / Y Axis

    Hi there.

    I'd like to create a scatter chart with just a horizontal / axis so that the dot will appear on a single line with values between 1 - 5. Alternatively, a single horizontal bar chart with similar values would work, too. I can't seem to figure out a way to completely remove the vertical / Y axis.

    I've been doing this with a manual method for a while, but it's time consuming. I've attached an image of this as an example of what I'd like to hopefully create automatically.

    Thanks for any help you're wiling to provide! This is driving me nuts and I can't seem to find any relevant information on removing the Y axis from an Excel chart, so I'm starting to suspect that it can't be done.

    Manual Sample.png

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Scatter Chart Without a Vertical / Y Axis

    Hi, welcome to the forum

    maybe work-around for this would be to set the axis to white (or whatever color will make it "disappear")?
    Also, Im sure there is somewhere to uncheck so you dont see the axis
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 2
    Last Post: 01-22-2015, 03:51 PM
  2. Replies: 1
    Last Post: 06-18-2014, 04:32 PM
  3. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  4. Add labels/titles to vertical axis of scatter chart
    By verwater in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-23-2013, 07:19 PM
  5. [SOLVED] How to draw a chart horizontal axis and vertical axis
    By kiany406 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2012, 02:56 PM
  6. Replies: 3
    Last Post: 06-19-2012, 06:51 PM
  7. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1