+ Reply to Thread
Results 1 to 2 of 2

How can I neatly overlay a line graph series over a scatter plot?

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    77

    How can I neatly overlay a line graph series over a scatter plot?

    I have two series of data that should be able to easily share an X and Y axis.

    Both series only have 12 unique values that should go on the X axis (one for each month in the 2015 year).

    The difference is that Series 1 has only 1 value which corresponds to each month (hence the line graph), while Series 2 has several (for the scatter plot).

    I want the scatter plot in the background with the line graph overlayed on top. It took me an hour just to figure out how to combine the line and scatter plot without major formatting issues (when I first tried simply changing the chart type of Series 1 to a line graph, almost all of the scatter plot points just dissappeared out of sight). Now I have it almost perfect, but part of the line graph is hidden behind the scatter points, and I would like to bring the line graph to the front. These are the steps I've taken to get it to this point:

    1. Insert a scatter plot of Series 1.
    2. Click "Select Data", and Add Series 2
    3. Right-click a data point for Series 1, Click "Format Data Series", and in "Series Options", choose to plot the series on the "Secondary Axis". A new Y axis appears on the right side of the graph in addition to the Y axis that was already on the left
    4. Right click a data point from Series 1, click "Change Series Chart Type", and make it a line graph
    5. Delete the right axis on the right of the chart
    6. How can I bring the line graph to the front?

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: How can I neatly overlay a line graph series over a scatter plot?

    Design Tab; in the Data group: click Select Data
    In Legend Entries on the middle-left, select the line graph data series (I presume it will be the bottom one) and click the arrow-up to the right of the [X Remove] button, which should push it to be above the scatter-plot series (which I guess would be the second one).

    That should change the draw order so the line series is on top of the scatter series.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. Converting Scatter plot to Line plot and back
    By SPDavern in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 10:49 AM
  2. Replies: 2
    Last Post: 11-11-2013, 05:37 PM
  3. Skip Blanks on Line Graph or Scatter Plot (Excel 2007)
    By Ctolson2344 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-15-2013, 04:04 AM
  4. [SOLVED] Multiple Criteria Line Graph/scatter plot
    By chumbawumba in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2012, 05:35 AM
  5. multiple series scatter plot graph
    By airone12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-09-2012, 07:46 AM
  6. 3rd Axis Line Graph Overlay Data Set Problem
    By joe.teixeira in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-11-2011, 03:26 AM
  7. [SOLVED] Scatter plot and line graph combination
    By Tim Gilderseeve in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2005, 03:05 AM
  8. Converting XY Scatter plot to Line Plot and back
    By SPDavern in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2005, 10:06 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