Results 1 to 3 of 3

Thread: Change x- and y-values in an excel dot chart

  1. #1

    Change x- and y-values in an excel dot chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have this problem getting my values to plot in a dot chart in the way I want and I cannot solve it for the love of my life. I hope someone can help me!

    I have a table with data that looks like this:


    Click image for larger version. 

Name:	excel.jpg 
Views:	9 
Size:	18.9 KB 
ID:	3276

    Blue being the sample names and orange the depths (in meter) where I have found the number of animals I've noted in the cell. The thing is I want to plot my chart in a way so that I have the depths on the y-axis from the top down, so that I start at 0 m going down to 2 m. And on the x-axis I want the numbers to be plotted from 0 where x and y cross, and the maximum number on myt right hand side, something like this:

    Click image for larger version. 

Name:	excel2.jpg 
Views:	7 
Size:	16.4 KB 
ID:	3277

    But I've got the numbers on my x-axis wrong, cause I want it to start with 0 on the left hand side, naturally... And I only achieved this by writing x values where y should be and the other way round, and that is not possible when I want to plot all 9 series... I hope someone can help me!!! I've asked around but noone seems to get how to do this, but then we are all just normal excel-users, no experts...
    Thank you!"!!!

    /Lisa

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    41
    Articles
    0
    Excel Version
    2016
    The data layout means you need to define the data used by each series manually.

    Add a xy-scatter chart and then use the Select data dialog to add new series.
    Attached Files Attached Files
    Cheers
    Andy

    www.andypope.info

  3. #3
    Wow!
    You are my hero!!!

Posting Permissions

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