+ Reply to Thread
Results 1 to 3 of 3

Problem creating scatter plot

  1. #1
    Registered User
    Join Date
    03-30-2021
    Location
    Malmo
    MS-Off Ver
    2020
    Posts
    2

    Post Problem creating scatter plot

    Skärmavbild 2021-03-30 kl. 13.35.56.png

    Any ideas why the scatter plot isn't correct?

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Problem creating scatter plot

    Hi,

    Is the normal decimal separator in Sweden a comma (,) instead of a point (.)? If so, your data won't be read as numbers.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    03-30-2021
    Location
    Malmo
    MS-Off Ver
    2020
    Posts
    2

    Re: Problem creating scatter plot

    God damn it youre right!! Thx a bunch!! Have the best day! EDIT: Just tried it and it worked of course!

+ 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. Help with creating line chart or scatter plot.
    By Elijah in forum Excel Charting & Pivots
    Replies: 23
    Last Post: 12-08-2018, 02:53 PM
  2. Creating scatter plot with mean/ SD error bars
    By aldo2014 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-24-2014, 10:48 AM
  3. Creating Lines On a Scatter Plot Help Please
    By richter394 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-10-2013, 09:27 PM
  4. creating a scatter plot of a partial correlation
    By GradStudent2010 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-17-2012, 09:55 PM
  5. Need help creating scatter plot of paired data
    By jondmeyer in forum Excel General
    Replies: 1
    Last Post: 05-18-2011, 11:58 AM
  6. Excel 2007 : Creating scatter plot graph
    By Grantmitch1@hotmail. in forum Excel General
    Replies: 1
    Last Post: 06-07-2010, 11:51 PM
  7. Creating a Scatter Plot for any # of data
    By TwoyTaylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2008, 10:07 AM

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