+ Reply to Thread
Results 1 to 3 of 3

Combining Area and Scatter data into a chart

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    3

    Combining Area and Scatter data into a chart

    Hi there. I have a series of X-Y Data (0-10 in both axis) that I want to overlay on an area chart to show outliers outside of an accepted condition. I have been able to create the area chart and the scatter chart separately but when I try to combine them the axis gets messed up. I tried using a secondary axis but I am not that skilled at this so I thought I would prove my wife wrong and this time ASK FOR DIRECTIONS!

    I have attached the data and my feeble attempts at creating this chart.

    thanks in advance

    g

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

    Re: Combining Area and Scatter data into a chart

    Hi,

    I do not see any attachment in your post. Can you please upload a sample template of your workbook here using "Go Advanced" option?

  3. #3
    Registered User
    Join Date
    02-15-2014
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Combining Area and Scatter data into a chart

    I attached the file again - not sure what I am doing wrong here. Hopefully this time it sticks!!

    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. How do you fill the area under an X-Y scatter chart?
    By Excel_Monkey in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 08-02-2012, 08:20 AM
  2. Create a Combined Chart for Stacked Area and Scatter
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 11-29-2010, 12:53 PM
  3. Adding an XY Scatter to an Area Chart
    By JimmyA in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2010, 05:24 AM
  4. 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
  5. combine area and xy scatter chart
    By ehamike in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2009, 06:11 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