+ Reply to Thread
Results 1 to 5 of 5

Pivot Chart for Scatterplot

  1. #1
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    255

    Pivot Chart for Scatterplot

    I have attached the following sheet which has some scatterplots.

    At the moment I have all my data plotted.

    My x-axis variable is temp and I would like to set up a way to look at these scatterplots by restricting the temp without needing to make extra charts.

    happy to discuss further.
    Attached Files Attached Files
    Last edited by pickslides; 03-22-2010 at 05:26 PM.
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Pivot Chart for Scatterplot

    What do you mean by "restricting the temp"? Can you explain a bit more?

  3. #3
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    255

    Re: Pivot Chart for Scatterplot

    Quote Originally Posted by teylyn View Post
    What do you mean by "restricting the temp"? Can you explain a bit more?

    e.g So the chart can look at temps between a given interval. User may want to look at Temps between 25 - 35 degrees.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Pivot Chart for Scatterplot

    Hi again.

    the way your data is layed out, it does not lend itself to a pivot table. Instead, you can create a helper column for the X value and then enter the temp range in two cells at the top of the sheet.

    See attached.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    255

    Re: Pivot Chart for Scatterplot

    Hi teylyn

    Its not quite what I had in mind but I think its clever and will get a lot of use out of that idea.

    Thanks very much.

+ 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