Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2010 scatter chart setting to make major horizontal axis by month

    Hi

    This post is in response to the following link.

    http://windowssecrets.com/forums/sho...-axis-by-month

    Because the file I wanted to add was too big for a response, but okay for a new thread I used this way.


    I saw the Excel file Steve posted and it's almost exactly what I need.


    The thing is, my chart is a scatter, and I can't select monthly at the major unit.
    When in your file, I changed the chart to a scatter, I got the same result as in my own chart...
    Vice versa I can select "monthly" when I change my chart to a line chart.


    Does anybody know if it's possible to set the time scale to monthly for scatters?
    Or maybe it's possible to have another type of chart look the same as mine now?

    Thanks in advance!

    Paul

    Help.xlsm

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi

    ..just noticed that no reply to your post has been made.
    So, here's my version attached, with the formatted month axis.
    I did this as follows, right-click on the horizontal axis to select it, then choose Format Axis..from bottom of the menu :

    rz-1.PNG

    rz-2.PNG

    rz-3.PNG

    rz-4.PNG

    zeddy
    Attached Files Attached Files

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 648 Times in 591 Posts
    Paul,

    You can use a line graph but make it appear as a scatter graph. In your link above, here is the graph that sdckapr provided left as a line graph. The series has been reformatted with the line set to "No Line" and the marker set to "Solid fill". This way you will still be able to format the horizontal axis by month and have the feel of a scatter graph.

    HTH,
    Maud

    Scatter.png

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •