+ Reply to Thread
Results 1 to 3 of 3

Scatter Plot

  1. #1
    Registered User
    Join Date
    11-30-2019
    Location
    /
    MS-Off Ver
    2016
    Posts
    1

    Scatter Plot

    Hey!

    If I want to make a scatter plot and I want to put in values in percentages for the x/y series values, the percentages become divided by 1000. How do I solve this and how can I make sure the exact values are being used?

    Thanks in advance!
    Attached Images Attached Images

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,929

    Re: Scatter Plot

    With the chart, right click on the axis to format, select number and chose percentage and you desired number of decimal places.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,448

    Re: Scatter Plot

    I'm not sure there is much we can do to debug this from a picture. The only thing I can suggest is to look at your decimal separator. The curious thing to me is -- if I assume that the value in B8 is three point three per cent (and not three thousand something per cent) -- is that the axis dialog seems to be using a . as the decimal separator (0.003%) where the spreadsheet cell is using a , for the decimal separator. I wonder if something is causing Excel to become confused.
    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)

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