+ Reply to Thread
Results 1 to 2 of 2

determine data series on x and y value axis in scatterplot

  1. #1
    Registered User
    Join Date
    04-17-2015
    Location
    Zurich, Switzerland
    MS-Off Ver
    2013
    Posts
    1

    determine data series on x and y value axis in scatterplot

    Dear skilled excel users,

    simple it sounds, but impossible it seems to be for me to solve.
    Data:
    I have monthly data values (snow height changes in millimeters) at different elevations (around 4800 meters).
    Goal:
    I want to display it in a scatterplot with the snow height change as the x-values und the elevation as y-values. Just as it is displayed in the graph in the attached xlsx.
    Problem:
    I would like to select the complete table and define the x and y axis values in order to look like the example table. I have found no way to do this but to choose for each single data series its name, x-range, and y-range. I have tables with hundreds of lines (data series), and defining it all manually would take me ... long. I'm sure there is some hidden way to achieve this in a few clicks?

    Desperately appreciating any help!
    Nico
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: determine data series on x and y value axis in scatterplot

    I dont know "few clicks" way - may be there is one, but ...

    You can easily achieve quick results with macro.

    * Insert empty scatterplot
    * Start macro recorder and insert one series manually.
    * Stop recording

    Press Alt+F11 to see the macro - it shall look similar to this one:

    Please Login or Register  to view this content.
    it will be not-so-tough to make it a bit more universal, like:
    Please Login or Register  to view this content.
    Delete the first series (or leave it if it was a good one), make sure your plot (empty?) is active, and run this macro
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. X-axis data is formula, cannot do scatterplot problem
    By t.jones in forum Excel General
    Replies: 3
    Last Post: 01-30-2012, 08:40 AM
  2. Circular line from axis to axis on scatterplot
    By burntoc in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-17-2010, 12:59 AM
  3. Scatterplot : X-axis Mod
    By Pierre.Felx in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-11-2009, 09:57 AM
  4. Replies: 1
    Last Post: 01-29-2009, 04:54 PM
  5. Scatterplot axis labels
    By mjamromi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2005, 12:45 PM

Tags for this Thread

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