+ Reply to Thread
Results 1 to 3 of 3

Scatter and Line Chart using same x axis?

  1. #1
    Registered User
    Join Date
    11-18-2011
    Location
    Ashburn, VA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Scatter and Line Chart using same x axis?

    Good Morning everyone, hope you're all having a good week so far. I apologize if this is something that's been asked before, but in searching the forums I did not find anything similar to what I was looking for.

    I'm trying to create a combination of a Line and Scatter plot. I'm putting together a correlation between Average Speed of Answer and Service Level in a call center.

    Ideally, the X Axis would show Service Level (descending from left to right from 100% to 30%, where no data below 30% exists in the data set), and the Y axis would show the Average Speed of Answer in m:ss format.

    The Scatter portion would display all of the raw data points from two years worth of data. If any day (FYI there is no date information in this chart, each day is considered equal for the purpose of this exercise) showed up at A Service Level (x axis), it would be plotted at B Average Speed of Answer (y axis).

    The line portion would display the mean average of all of the ASA's at each individual SL%.

    Visualizing it in my mind, I know I could manually draw this in one graph. Both the Line and Scatter share the exact same X and Y axes, including upper and lower limits.

    I cannot for the life of me figure out a way to force it all on one graph and one X axis without A) plotting the Line or Scatter on a secondary axis or B) the scatter portion being thrown out of scale so badly that it's all against the Y axis line at 100%.

    EDIT: The reason I want to force it all onto one axis is because then, I can add an additional set of data (how Abandonment Rate and Service Level are correlated) that definitely uses a different Y axis even though the X axis would, once again, be shared.

    I've uploaded what it should look like (when I use a secondary axis), what it actually looks like (when I try and force the same axis) and the data associated with it.

    Thank you all in advance, and have a great rest of your week!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by SpreadsheetNublet; 01-23-2019 at 12:55 PM.

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

    Re: Scatter and Line Chart using same x axis?

    I am not sure I understand the need for a scatter + line combination chart. When I do similar things, I just use a scatter chart for both series. The raw data series is formatted as "markers without line" (through the format data series dialog) and the ":average" data series is formatted as "line without marker". It should be as simple as selecting each data series -> Format -> format selection -> Choose the appropriate marker and line options.

    Am I misunderstanding something?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-18-2011
    Location
    Ashburn, VA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Scatter and Line Chart using same x axis?

    Nope, you're not. It really was that simple. I figured it was something stupid like this. I feel like a numpty now. XD

    THANK YOU!

+ 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. [SOLVED] X-axis of scatter chart: Tick mark and X-axis label for every data point
    By JayUSA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2018, 02:38 PM
  2. Replies: 3
    Last Post: 10-25-2017, 03:30 AM
  3. [SOLVED] Add Year Values to X Axis in Scatter or Line Chart
    By sherylt13 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2015, 05:21 AM
  4. Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place
    By Cheekybeelzebub in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2015, 09:33 AM
  5. Replies: 3
    Last Post: 06-19-2012, 06:51 PM
  6. Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  7. Replies: 0
    Last Post: 03-22-2012, 09:46 AM

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