+ Reply to Thread
Results 1 to 3 of 3

Plotting a delta between two data points

  1. #1
    Registered User
    Join Date
    08-24-2017
    Location
    Brussels, Belgium
    MS-Off Ver
    2013
    Posts
    1

    Plotting a delta between two data points

    Hello,
    I would like to plot a bar that represents the difference between two points. In my case these are a starting price (in an auction) and a final sale price. So for example starting price 10, selling price 13. I would like to plot a bar that goes from 10 to 13, so "floating' in my chart space.
    I have a series of items sold on my x-axis and prices from 0 to my 50 on my y axis.
    Can someone help?
    Thanks
    Kate

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Plotting a delta between two data points

    Something like this?

    See the attached file.
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Plotting a delta between two data points

    or use Waterfall chart

+ 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. I want to find the closest point to the origin using delta X and Delta Y.
    By dcmapper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 05:05 AM
  2. Plotting data to show pinch points over a week
    By OillyBob55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2015, 05:48 PM
  3. Plotting thru 2 fixed points
    By celliott in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-29-2014, 06:23 PM
  4. Replies: 1
    Last Post: 08-29-2013, 12:03 PM
  5. Plotting points using VBA
    By adilson.perez in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-08-2011, 10:37 PM
  6. XValue Data Points Not Plotting Correct Values
    By shephejm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-24-2009, 08:42 PM
  7. Pie Chart plotting 1 single color for multiple data points
    By moonseed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-12-2008, 03:41 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