+ Reply to Thread
Results 1 to 5 of 5

Help with Dates on X axis (scatter plot)

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    CS, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Help with Dates on X axis (scatter plot)

    Hello,

    I've been tinkering with this data for a while and I've gotten it to display the correct range of dates along my x axis, however I would like to know how to get the specific dates these samples were collected.

    For example, I am doing a scatter plot where my x values (dates) are February 2012, April 2012...April 2013 and there are multiple y values per date. From snooping around this site and google, some have suggested that "Axis Options" and select "Text" will fix my problem, and I am sure it would, HOWEVER my Axis Options doesn't have the option Text for me to select.

    I know it is possible for line graphs, but I really need this data presented as a scatter plot. Below is everything I've tried to do:

    -Add my data as a line graph first and then change it into a scatter plot, doesn't work, it only takes into consideration ONE date only and I have multiple dates.
    -As a scatter plot, fixed my x ranges (min/max, and major/minor), this is the closest I've gotten to what I wanted... but it's not good enough

    I'm sure I did other things, but I can't type them all out right now.

    Thanks for any help!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Help with Dates on X axis (scatter plot)

    A sample file would probably help us understand better exactly what you want.

    My first impression is that you want something based on Jon Peltier's Arbitrary Axis technique: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    CS, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with Dates on X axis (scatter plot)

    Thanks, I would like to attach a sample file, but I don't see an attachment option here... So I inserted an image of it instead.Excel_Help.jpg

  4. #4
    Registered User
    Join Date
    02-12-2014
    Location
    CS, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help with Dates on X axis (scatter plot)

    Here it is attached. Didn't know I had to "Go Advanced"Data_excelforum_help.xlsx

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Help with Dates on X axis (scatter plot)

    It looks to me like the Arbitrary Axis technique should do just fine.

    1) In an out of the way place in the spreadsheet, put the data you will use for the axis markers
    2) Add that series to the chart
    3) Label that series with Rob Bovey's XY chart labeler add-in
    4) Hide the existing axis marks and labels if desired

    Details are in Peltier's tutorial mentioned above.

+ 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. XY Scatter Plot with 1st of month on X axis
    By teylyn in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-04-2016, 03:17 AM
  2. Custom x-axis on scatter plot involving dates
    By carrollkm in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-27-2013, 04:41 AM
  3. Excel 2007 : Scatter Plot-Changing the X-axis HELP!
    By Pacinterp in forum Excel General
    Replies: 1
    Last Post: 04-07-2011, 04:11 AM
  4. How to Plot Scatter Diagram with unequal/ arbitrary dates on X axis
    By ranjana in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-07-2010, 02:16 AM
  5. [SOLVED] Double y-axis scatter plot.....?
    By Chikngizrd in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-06-2005, 12:50 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