Excel Combine Two Graphs Into One


Select bar and press Ctrl + 1, which will open up the “Format Data Series” option to the right of the chart. Step 9: In this “Format Data Series,” option makes “Gap Width” to 0%. Step 10: As we can see in the above image, as soon as we make the “Gap Width” to 0%, all the bars are combined together. You need to combine several charts into one chart. If you need to create a chart that contains only one primary and one secondary axes, see Using two axes in the one chart. Excel uses only two axes in one chart: primary and secondary. If you want to use.


Below is a graph of the tensile strength of one type of aluminum:

The graph has been selected by clicking just inside the outer box of the graph. Notice that when the graph is selected, black boxes (or 'handles') show around the perimeter. With the graph selected, you can also see the independent (Strain) and dependent (Stress) data highlighted to the left in purple and blue, respectively. Because the graph only has one independent variable, there is no need to have a legend. Information about what the independent and dependent variables relate to is in the title.


In this example, both the first and the second graph and their data are on the same worksheet page:

Notice that the independent and dependent variables are identical, though the ranges of the scales are slightly different. The second graph has Stress values ranging up to approximately 70000 psi, compared to 13500 psi on the first graph. The second graph has Strain values only up to approximately 0.20 in/in compared to 0.38 in/in on the first.

To superimpose the two graphs, you should first create a copy of one of the graphs to use as a base for the new graph. You want a copy in case something happens during the superimposition process. To copy the graph:

  • Select the first graph (1100 Aluminum in this case) by clicking somewhere just inside the outer box (the back box handles will appear around the perimeter).
  • Choose Edit>Copy from the menu.
  • Click in a new spreadsheet cell that represents, approximately, the upper left hand corner of where you want the new graph to go.
  • Choose Edit>Paste from the menu.

This new copy will be used as the base for the superimposed graph. Now select the second graph to begin the superimposition process:

  • Select the second graph (e.g., 2024 Aluminum) so the handles appear.
  • Choose Edit>Copy from the menu.
  • Click on the copy of first graph (e.g., 1100 Aluminum) so the handles appear.This is a critical step since it indicates the target of where the second graph is to be copied.
  • Choose Edit>Paste from the menu.

The new, superimposed graph should now show both sets of data:


Excel Combine Two Graphs Into One Excel


How To Combine Two Graphs Into One In Excel

Notice that it has taken the title from the second graph (2024 Aluminum). Also noticed that while the dependent variable scale (Stress) adjusted to accommodate the larger range of the second graph, the independent variable scale clipped the larger range of the first graph.