+ Reply to Thread
Results 1 to 4 of 4

Three line charts on one?

  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    4

    Three line charts on one?

    Hi,

    I have 3 line charts which represents data for 3 months. I would like now to compare all this three line on one chart.
    I have tried many times, and looked for solutions but the online tutorials didnt help. I even tried creating a chart by selectoing on one chart all the data that comes from the other 3, but i am not sure if its the correct way.
    I would be grateful for help.
    charts.JPG

    Thanks

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Three line charts on one?

    Hello and welcome to the forum.

    You should be able to copy the Jul graph then select the Aug graph and Ctrl V. That should combine the two. Then copy that graph and paste it into Sep.

    I can't really see any details from the pictures. A sample workbook would be better.

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Three line charts on one?

    If your x-axis is the same for each data set (dates?), can you not just include them all in one chart? I can't make out the details from your pictures, so please attach a sample workbook.
    Make sure there is enough data to demonstrate your need but not so much that the file is too big (if you have 10,000 rows of data, you don't need to leave them all in, for example). Include before and after sheets in the workbook if needed to show the process you're trying to complete or automate. Make sure you include the answers you want to get - put examples in, with notes if necessary to explain details.
    Remember to remove any confidential information or, if a cell needs data in it to work, overwrite it with made-up data.
    The paperclip icon doesn't work at the moment, so click on Go Advanced under the reply box and then scroll down to Manage Attachments to attach a file.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Three line charts on one?

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Blank/NA values to be shown as dotted line rather than straight line in Charts
    By palaniappan0212 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2016, 01:01 AM
  2. Replies: 3
    Last Post: 08-28-2012, 09:16 AM
  3. Excel 2010 Charts - Line Graph - How to specify which line is on top?
    By AdamParker in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2012, 11:24 AM
  4. three charts and one line?
    By demo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-10-2011, 03:59 AM
  5. line charts
    By jadedmonkey in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-12-2009, 02:28 AM
  6. Excel 2007 : Line Charts
    By Miller60six in forum Excel General
    Replies: 5
    Last Post: 05-22-2009, 05:52 AM
  7. [SOLVED] LINE CHARTS
    By Aurora in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2006, 12:10 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