+ Reply to Thread
Results 1 to 15 of 15

Compare 2 Sets of data and meger into 1 chart

  1. #1
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Compare 2 Sets of data and meger into 1 chart

    Hi

    I am do some data comparison over 2 years (see attachment). How do I merge the 2 sets of data into 1 chart to compare the progress monthly. Please suggest the best way to compare the data.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Compare 2 Sets of data and meger into 1 chart

    something like that?
    (adjust colors by yourself)

    If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Thank you for the assistance. The overall view is overcrowded and confusing. Is there a better way?

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Compare 2 Sets of data and meger into 1 chart

    Try change chart type and choose the best for your needs

    maybe this one
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Compare 2 Sets of data and meger into 1 chart

    Maybe that way?
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Hi. This is fantastic. But I do not know how to extend till Dec 16 and Dec 17. Please advise/assist to add 1 more coloumn for "Type C". Thank you for your lovely chart.

  7. #7
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Compare 2 Sets of data and meger into 1 chart

    The chart is based on a pivot table. The data source for the pivot table is Table.
    Add further data in the Table and refresh PT. By entering further data in the Table, add a date - the year and month will automatically appear (see formulas), Type and value.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Hi

    I do not how to edit the pivot table:
    1)Edit the name of the slicer - Type A=Inpatient, Type B=Home Visit, Type C=Total
    2)Edit the Pivot Table to show Jan to Dec

  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Compare 2 Sets of data and meger into 1 chart

    Simply right click on the Pivot Table the click Refresh

    I forgot to add about Jan-Dec (with your example)
    1. in C2: =TEXT([@Date],"mmm")
    2. Pivot table options
    3. Display
    4. untick Classic PivotTable.. blablabla
    5. Ok
    6. Right click on PT and Refresh


    or like in att.
    Attached Files Attached Files
    Last edited by sandy666; 07-18-2017 at 12:58 PM.

  10. #10
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Thank you. But why there is a "2" behind Jan (eg Jan2, Feb2....)

  11. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Compare 2 Sets of data and meger into 1 chart

    delete this pivot and create new

  12. #12
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Please help me. I do not know how to creat pivot table. Thank you.

  13. #13
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Compare 2 Sets of data and meger into 1 chart

    click on table
    from the ribbon - Insert - PivotTable
    you will see PivotTable Fields
    drag appropriate elements to appropriate areas

    Create a PivotTable to analyze worksheet data

    Create a PivotChart
    Last edited by sandy666; 07-19-2017 at 06:20 AM.

  14. #14
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Hi. Thank you. Will definitely learn and master it. In the meantime, please assist with the current worksheet by removing "2" behind Jan (eg Jan2, Feb2....). Thank you.

  15. #15
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Compare 2 Sets of data and meger into 1 chart

    Thank you for the link. I resolved my problem.

+ 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 To Compare Two Sets Of Similar Data Sets To Find a Good Match
    By Mark123456789 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 01:29 AM
  2. Need Help - How to compare two sets of data?
    By adamnyc31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2014, 11:07 AM
  3. Formula to compare two different data sets
    By twoheadedgames in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-13-2014, 08:46 PM
  4. Macro to Compare two sets of Data
    By idorward in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 02:25 AM
  5. Compare two data sets
    By VIJEXCEL in forum Excel General
    Replies: 1
    Last Post: 02-29-2012, 07:11 AM
  6. Compare two sets of data
    By Hollyoak08 in forum Excel General
    Replies: 3
    Last Post: 03-09-2010, 05:54 AM
  7. Compare two sets of data
    By Bhupinder Rayat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2005, 06:05 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