+ Reply to Thread
Results 1 to 4 of 4

Combining Chart together. One Scatter, one Scatter with Line

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    424

    Combining Chart together. One Scatter, one Scatter with Line

    I have a timeline which show the flow of my Process. We have Process A to E.
    HOwever, i wan to highlight the Day difference between Process E and C. Hence i wan another line to show the difference. HOwever, i am not able to combine.

    Would appreciate if someone can advice. Please refer my attachment for clearer picture.
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,899

    Re: Combining Chart together. One Scatter, one Scatter with Line

    Its not perfect but you can copy one over the top of the other by turning the background off and simply laying them over each other. If the charts are going to have variable ranges though you might want tp set the x axis to the same ascale on both to keep them aligned and it might look neater if you turned off one of the scales too.
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    424

    Re: Combining Chart together. One Scatter, one Scatter with Line

    is there any way to make both chart exactly the same size beside manually adjusting? n aso, if i lay one exactly on top of the other. how do i group both tgt? i cant seems to select both at the same time.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,730

    Re: Combining Chart together. One Scatter, one Scatter with Line

    Use the Select Data option to add a new series.
    Edit the new series x and y values
    Format line and remove markers
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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] Scatter and Line Chart using same x axis?
    By SpreadsheetNublet in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-23-2019, 02:58 PM
  2. Replies: 0
    Last Post: 06-14-2017, 05:14 PM
  3. Custom scatter chart with a line
    By elyse13 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2017, 07:34 PM
  4. Combining Area and Scatter data into a chart
    By Fenguin62 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-17-2014, 10:38 AM
  5. Line and Scatter chart problems...
    By aboothby in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-26-2006, 09:55 AM
  6. Excel Line or Scatter Chart
    By Millie in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-14-2006, 01:20 PM
  7. How do I put a regression line on a scatter chart
    By Charles Hall in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2006, 10:25 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