+ Reply to Thread
Results 1 to 4 of 4

Increment X-axis by month for plot

  1. #1
    Registered User
    Join Date
    01-20-2023
    Location
    North West Florida
    MS-Off Ver
    2016
    Posts
    2

    Increment X-axis by month for plot

    In the attached, I'm sampling A,B, and C at least twice a month and I'd like xlabels to increment monthly, but in a way where there are no repeated months. Right now it looks like the spacing is dictated by number of days.
    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: Increment X-axis by month for plot

    You need to summarise the data and then chart it.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-20-2023
    Location
    North West Florida
    MS-Off Ver
    2016
    Posts
    2

    Re: Increment X-axis by month for plot

    Thanks, but I'm not looking to sum all of the observations for each month, rather I'd like them to be discretely plotted but within the same month block. Right now, the intervals for the x-axis are picked in such a way that some months are repeated (Feb, April, June) and I want it so that the month is shown only once.

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

    Re: Increment X-axis by month for plot

    In that case use a line chart instead of xy-scatter.

    With a line chart you can make the horizontal axis a Date one and set the period to Months.

    You will need to use line chart with markers and then format each series to have no Line.
    Attached Files Attached Files

+ 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. [SOLVED] plot different datasets with same horizontal axis in 1 plot
    By CJdR in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2021, 03:55 PM
  2. Replies: 5
    Last Post: 05-03-2020, 06:01 AM
  3. Replies: 7
    Last Post: 06-18-2019, 03:50 PM
  4. 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
  5. Replies: 2
    Last Post: 03-17-2013, 03:57 AM
  6. Replies: 0
    Last Post: 06-13-2007, 09:41 AM
  7. dot plot - single x axis location with multiple y axis dots
    By EJF in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-22-2006, 10:15 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