MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 529|Reply: 13

Combine Two tables in One Graph

[Copy link]

3

Topics

4

Posts

25

Integral

Member

Rank: 2

Integral
25
Post on 2-9-2017 05:10:47 | All posts |Read mode
Pardon my ignorance.
Is there a way I can merge two tables into a single graph? Like I have the amount and count of specific activity in a month. Please see attached for reference.








  • Combine two Tables in single graph.xlsx
    (9.8 KB, 1 views)
    Download

  • Reply

    Props Report

    0

    Topics

    17

    Posts

    54

    Integral

    Member

    Rank: 2

    Integral
    54
    Post on 2-9-2017 09:58:36 | All posts



    you can just add series to the chart from each table. it's not real clear what you want the chart to look like but you'll need two values axes since the scales of the values are very different











    Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 10:53:53 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 13:23:55 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 2 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 15:24:52 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 5 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 17:20:57 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 9 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 19:31:26 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 11 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 21:53:43 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 13 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-9-2017 22:27:55 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 16 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    147

    Posts

    340

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    340
    Post on 2-10-2017 01:03:57 | All posts



    You can use a pivot table








  • Combine two Tables in single graph.xlsx
    (20.3 KB, 18 views)
    Download

  • Reply Support Opposition

    Props Report

    12Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-19-2017 16:21 , Processed in 0.368338 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!