Results 1 to 2 of 2

How to plot only selected values on the scatter chart?

Threaded View

  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

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