+ Reply to Thread
Results 1 to 1 of 1

Show interval points on scatter plot

  1. #1
    Registered User
    Join Date
    05-19-2014
    Posts
    9

    Show interval points on scatter plot

    This question is going to require you to look at the actual file I am looking at. However, the file is very large, so I am attaching a condensed version of it for the sake of allowing you all being able to view it.

    I am building a tool that compares two data series. I have the data laid out the way I want it, and the chart built. However, now I want to incorporate something new into this chart. In cells D3:F6, there is a table showing 4 different intervals, 20/40/60/80 %. There is then a VLOOKUP attached to two different pivot tables, showing the point at which these thresholds are crossed in terms of the rolling total of dollar sales.

    I have built a scatter plot attached to these rolling sales numbers. What I need is a way to add points to each of these lines showing the number of products at which each threshold is crossed. So when the first line crosses 20% on the X axis, have a point on the line with (in this case) the number 3 attached to it, signifying that it takes 3 products to generate 20% of the dollar sales.

    In the original file this is all pivot data, and there are five different filters on each pivot table, so it cannot be a static solution. It needs to be attached to the pivot data, so that it will change when the table is changed.

    I hope that this makes sense, please comment if it needs to be clarified. And I really hope that someone can help me out. Thanks!
    Attached Files Attached Files

+ 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 Graph to show data along side scatter points
    By jonathan.haynes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2013, 08:59 AM
  2. Scatter Plot Skip Interval
    By Smed in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-10-2009, 05:50 AM
  3. Only plot scatter points that have both an X and a Y value (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2009, 04:23 AM
  4. How do i show duplicate data points on a scatter plot?
    By Mr.Man in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2006, 11:10 AM
  5. [SOLVED] Scatter plot points x and y coordinates
    By Milo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2005, 07:25 PM

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