+ Reply to Thread
Results 1 to 4 of 4

Scatter plot - plotting multiple series using only two columns

  1. #1
    Registered User
    Join Date
    02-02-2015
    Location
    TX, USA
    MS-Off Ver
    2007
    Posts
    1

    Scatter plot - plotting multiple series using only two columns

    I am wanting to automate building scatter plots. I have four columns of data. A is the well name, B is the date, and column C and D are production values. I want to plot only the days the well is only, so column E calculates the number of producing days. The problem is I am continually adding new production days and having to insert rows between Well A and B. It would make things a lot easier if each time I updated the graph I could repaste all the data with the new data included (this is how I receive the data).


    Please see attachment for the data layout and graph.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Scatter plot - plotting multiple series using only two columns

    I'm not exactly sure what you are trying to do, but if the problem arises because of your formula in column E for production day, try this formula instead, entered into E2 and dragged down:

    Please Login or Register  to view this content.
    Hope this helps!
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Scatter plot - plotting multiple series using only two columns

    Here's how I would do this:

    1) Add a couple of helper columns F and G. F1 will be "Well A" and G1 will be "Well B".
    2) F2 and copied down F and G =IF(A$1=$A2,$C2,NA()). We will be using the charting property of the N/A error described here http://peltiertech.com/mind-the-gap-...g-empty-cells/ to block charting of each point.
    3) Now each charting series will point to the appropriate column, F or G, as far down as needed.

    As you add rows, the formulas in E, F, and G should update appropriately and the chart should as well.
    If you need to add additional wells, simply add more columns and copy the formulas across.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Scatter plot - plotting multiple series using only two columns

    ... or my attempt. Copy/paste updated data into columns A-D
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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 Chart with multiple series
    By hyattj in forum Excel General
    Replies: 0
    Last Post: 08-14-2014, 03:36 PM
  2. Scatter plot multiple series
    By mitchurugie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2013, 11:59 AM
  3. multiple series on a scatter plot
    By RobynB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-17-2011, 07:51 PM
  4. Multiple series on a X-Y scatter plot quickly
    By gregoir in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-23-2010, 04:53 AM
  5. Error while plotting multiple series on same plot
    By yogk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-16-2008, 04:15 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