+ Reply to Thread
Results 1 to 3 of 3

Combine two charts

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Combine two charts

    So I am having another Excel issue

    I created a small table and two graphs based on that table. Now I want to combine both graphs so that the Min to Max Graph is in the back with only the orange bars layerd ontop of the black bars.
    Is that possible?
    And is there a way to write the true headers next to the bar charts? So T and C instead of 2 and 1?
    thanks for your help
    MrMoody
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Combine two charts

    Now I want to combine both graphs so that the Min to Max Graph is in the back with only the orange bars layerd ontop of the black bars. Is that possible?
    Yes, it is possible. I am not sure where this fits into your project, but what I see in your description is a "box plot" (no whiskers). Your current chart is a stacked bar chart, which is the standard way to generate a box plot (before 2016 made a built in box plot option which I am not familiar with). See this tutorial: https://peltiertech.com/excel-box-an...ams-box-plots/

    In your sheet, I:

    1) Copied B1:C1 (T and C) and pasted into G1:H1
    2) Copied "start min" (B4:C4) and pasted into G2:H2
    3) Entered a formula for "start med" in G3 =B2-B4. Copied into H3
    4) Copied "End Med" and pasted into G4:H4
    5) Entered a formula for "End max" in G5 =SUM(B4:B5)-SUM(G2:G4) and copied into H5
    6) Selected G2:H5 -> Insert -> Stacked bar chart -> Switch row/column (and any other data series fixes I need).
    7) Format chart as desired.

    My approach here assumes that this is the final product, but I actually suspect that the data in B and C are coming from somewhere else, so it might be better to base the formulas in G and H on the actual source data and not the summary in B and C.

    And is there a way to write the true headers next to the bar charts? So T and C instead of 2 and 1?
    Note that in my approach, Excel automatically chose to use row 1 (G1:H1) as the category axis labels. In your original charts, you are telling Excel to use row 7 (A7:O7) as the category axis labels. A bar chart (with a category axis) will use whatever text you enter into the range designated as the category axis labels. Your charts are using 1 and 2 as the category axis labels, because those are the values in A7 and B7. If you want T and C to be used instead, either enter T and C into A7 and B7, or point the category axis labels range to be B1:C1.

    Does that help?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Re: Combine two charts

    Thank you for your help. It worked perfectly with a small mistake. I had to change the formula in G5 to B5 - B4 and copy that to H5 instead of Sum(G2:G5).

+ 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 combine multiple charts in one?
    By papaja in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-24-2013, 04:57 PM
  2. combine different charts
    By csolbach in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-11-2009, 08:46 AM
  3. Two charts in one - how to combine?
    By MikeOwl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-12-2008, 01:45 PM
  4. [SOLVED] need to combine two charts
    By Phill Costello in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-19-2006, 12:20 AM
  5. Combine Charts
    By Chi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-20-2005, 01:25 PM
  6. [SOLVED] How do I combine two different charts?
    By BG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2005, 11:06 PM
  7. Can I combine these charts?
    By mahmood in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-18-2005, 04:58 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