+ Reply to Thread
Results 1 to 4 of 4

scatter chart plotting more than data table contains

  1. #1
    Registered User
    Join Date
    09-01-2022
    Location
    kettering england
    MS-Off Ver
    excel 2000
    Posts
    5

    scatter chart plotting more than data table contains

    Hi, I have 3 times on the same day with 3 data values, say today at 3pm, 4pm and 5pm. next to them 3 data values. I want a scatter graph. The graph plots extra points between my values with no associated data value. The chart even starts with a time before 3 pm. Help please.

  2. #2
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: scatter chart plotting more than data table contains

    Hi
    Without seeing the file, I wonder and ask you: why use a Scatter Plot?
    Wouldn't a Line Graph be better?

    Hi, Mario

  3. #3
    Registered User
    Join Date
    09-01-2022
    Location
    kettering england
    MS-Off Ver
    excel 2000
    Posts
    5

    Re: scatter chart plotting more than data table contains

    Hi - the results are time based so I need a scatter graph, thanks

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

    Re: scatter chart plotting more than data table contains

    You may need to help us understand exactly what is happening and what "errors" are present. Reading between the lines, what you describe sounds perfectly normal for a scatter chart. If I create a scatter chart with x values of 0.625 (15:00), 0.66667 (16:00), and .70833 (17:00) -- then Excel's default axis limits algorithm will choose a value just smaller than the minimum value in the x axis data set for the axis minimum (my version chooses a value of 0.62 [14:52:48]), something larger than the largest value for the axis maximum (my version chose 0.72 [17:16:48]), and a reasonable value for the distance between axis tick marks (my version chose 0.02 [00:28:48] so there would be 4 evenly spaced tick marks between max and min. All of that should be normal, expected behavior for a scatter chart. Sometimes, we dislike the values Excel defaults to for axis max, min, and major unit values -- especially when those values represent time -- but we can easily go into the format axis dialog and enter values that we like better for the axis parameters.

    If I'm understanding the "problem" correctly, the solution I see is to simply enter the desired axis parameters into the format axis dialog. If you want the axis to start at 15:00 and end at 17:00 with tick marks spaced every hour, then enter values of 15:00 (0.625 if your version of Excel does not support direct time entry into the fields of the format axis dialog) for axis minimum, 17:00 (0.708333...) for the axis maximum, and 1:00 (0.0416666...) for the major unit.

    Did I understand the "problem" correctly, or is there something happening in your spreadsheet that I am not anticipating?
    Last edited by MrShorty; 03-06-2024 at 02:18 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Scatter chart plotting
    By TessG in forum Office 365
    Replies: 1
    Last Post: 09-10-2020, 09:23 AM
  2. Finding data and plotting a scatter chart with VBA
    By desperados2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-05-2017, 09:41 AM
  3. Plotting a circle on a scatter chart
    By Enlighten Me? in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-05-2015, 10:05 AM
  4. Scatter chart not plotting actual x-values
    By Gumby_Dammit223 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-31-2013, 12:03 PM
  5. Plotting scatter chart with grouped cells
    By dsalter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-28-2013, 07:44 PM
  6. Plotting XY scatter chart
    By melrosetutu in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2012, 08:01 AM
  7. [SOLVED] scatter chart insists on plotting as a line chart
    By Knows too little in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-11-2005, 03:06 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