+ Reply to Thread
Results 1 to 5 of 5

Time Scale for Scatter Chart

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    SG
    MS-Off Ver
    MS Excel 2019 & 365
    Posts
    241

    Time Scale for Scatter Chart

    Hi,

    Please assist in the Time Scale at X axis as per the attached file.
    I can get the time correctly set at bar chart but not the scatter chart.

    Thanks in advance.
    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,419

    Re: Time Scale for Scatter Chart

    Those are not real times but simply text.
    In the column chart that is okay as the axis is categorical and showing text.
    In a scatter chart the xvalues can not be used as they are text. Therefore the chart defaults to a numeric sequence of 1,2,3 etc.

    You need to create actual times in those cells. Note that then the points will all appear in the same horizontal position as the time is the same
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    02-23-2015
    Location
    SG
    MS-Off Ver
    MS Excel 2019 & 365
    Posts
    241

    Re: Time Scale for Scatter Chart

    Thanks, Andy.

    I managed to set it and plot the scatter chart.
    Would need some advise how to read/interpret the x axis values.
    Attached Files Attached Files

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

    Re: Time Scale for Scatter Chart

    In what way?

    If you mean the scale min/max/major/minor values then they are times in numeric format, which is 1 day = 1, 12 hours = 0.5

  5. #5
    Forum Contributor
    Join Date
    02-23-2015
    Location
    SG
    MS-Off Ver
    MS Excel 2019 & 365
    Posts
    241

    Re: Time Scale for Scatter Chart

    Thanks, Andy.

    Got it.

    Capture.JPG

+ 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. Chart Min and Max Scale change Run-time Error
    By webharvest in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2015, 04:26 AM
  2. Replies: 10
    Last Post: 07-21-2014, 11:11 AM
  3. Replies: 1
    Last Post: 07-17-2014, 11:04 AM
  4. XY Scatter Graph - auto time scale adds extra days
    By f_b_ilies in forum Excel General
    Replies: 4
    Last Post: 01-27-2011, 12:59 PM
  5. Gantt Chart with both date & Time scale
    By karthikcoep in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-02-2009, 04:18 AM
  6. Scale on X & Y Axis of the scatter chart
    By chanyke in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-27-2006, 09:01 PM
  7. [SOLVED] Changing Time Scale to Seconds on Excel Chart
    By JaneinPA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-08-2006, 05:30 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