+ Reply to Thread
Results 1 to 2 of 2

How to plot only selected values on the scatter chart?

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    46

    How to plot only selected values on the scatter chart?

    Hi,

    How to select from a column only those values that are equal to 0.00 and those values that are more than 0.00 but less than 0.50 and plot them as separate data variables on the scatter chart?

    The sample data is attached.

    Thank you,
    Gabriele
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to plot only selected values on the scatter chart?

    I did not look at your file, but how about if you could extract those values toi another table, andthen base the plot from that?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Scatter plot and Bar chart
    By hakki13 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-09-2014, 07:06 AM
  2. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  3. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  4. How to plot a scatter chart
    By bouncey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2011, 08:03 AM
  5. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM

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