+ Reply to Thread
Results 1 to 3 of 3

Shifting horizontal axis labels on a Scatter Plot

  1. #1
    Registered User
    Join Date
    10-29-2020
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    2

    Unhappy Shifting horizontal axis labels on a Scatter Plot

    Kind of an unusual problem I've been trying to solve for a while -- I have some data that is plotted on a scatter plot, and I would like to have the horizontal axis labels as 1000, 1500, 2000, 2500, 3000, and 3500, with minor tick marks every 100. Problem is, I need to include data from 600-3500. I would need to begin my labeling not at my minimum value, but at 1000. I have generated some sample data and will post the example sheet here. Any ideas are appreciated, note that I only need the plot output, the sheet "cleanliness" is not an issue here.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Shifting horizontal axis labels on a Scatter Plot

    Standard approach for labelling an axis with labels that are not in sync with built in values is to create you own with a dummy series.

    The dummy series has points where you want a value.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-29-2020
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    2

    Re: Shifting horizontal axis labels on a Scatter Plot

    You're a lifesaver! Thank you!

+ 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. Adding horizontal (category) axis labels on an X-Y scatter plot
    By chetanchimate in forum Excel General
    Replies: 6
    Last Post: 01-01-2016, 11:40 PM
  2. Replies: 2
    Last Post: 10-19-2015, 02:59 AM
  3. Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  4. Horizontal axis limiting formula in xy scatter plot
    By S K ROY in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-06-2011, 09:15 AM
  5. How to plot scatter graph on horizontal axis
    By alsupport in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2010, 04:53 AM
  6. XY Scatter: Changing Horizontal Axis Labels
    By smurray444 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-16-2007, 11:52 AM
  7. Shifting the position of x-axis labels
    By den1s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2006, 08:10 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