Excel Tutorial: How To Put Two Graphs Together In Excel

Introduction


Combining two graphs in Excel can be essential when you want to compare and analyze multiple sets of data at once. It allows you to present a more comprehensive picture and make better-informed decisions. In this tutorial, we will walk you through the step-by-step process of putting two graphs together in Excel, so you can create more impactful and visually appealing presentations of your data.


Key Takeaways


  • Combining two graphs in Excel is essential for comparing and analyzing multiple sets of data at once.
  • Understanding the data sets and identifying the common variable or axis for both graphs is crucial.
  • Customizing and arranging the graphs on the same sheet can make the presentation more visually appealing and impactful.
  • Linking the graphs by adjusting axis, scales, and adding labels can ensure consistency and clarify the relationship between the two graphs.
  • Practicing combining graphs in Excel can enhance data presentations and lead to better-informed decisions.


Understanding the data


Before combining two graphs in Excel, it's essential to understand the data that will be used for the graphs.

A. Assess the data sets that will be used for the graphs

Begin by reviewing the data sets that will be utilized for creating the graphs. Ensure that the data is complete and accurate, and that it contains all the necessary information for the graphs.

B. Identify the common variable or axis for both graphs

Next, identify the common variable or axis that will be used for both graphs. This could be a time period, category, or any other variable that will enable the graphs to be effectively compared and combined.


Creating the first graph


When it comes to creating graphs in Excel, it's important to ensure that they are clear, visually appealing, and effectively convey the data. Here's how you can create the first graph:

A. Select the data for the first graph

Before you can create a graph, you need to select the data that you want to include. This can be done by clicking and dragging to select the range of cells that contain the data.

B. Choose the appropriate chart type

Once you have selected the data, navigate to the "Insert" tab and select the type of chart that best represents the data. This could be a bar graph, line graph, pie chart, or any other type of graph that suits your needs.

C. Customize the chart to make it clear and visually appealing

After you have created the graph, it's important to customize it to ensure that it effectively conveys the data. This can be done by adjusting the colors, fonts, gridlines, and other visual elements. Additionally, you can add titles, labels, and legends to make the graph more informative.


Creating the second graph


Once you have successfully created the first graph and inserted it into your Excel worksheet, you can proceed to create the second graph to visually represent your data. Here's how you can do it:

A. Select the data for the second graph
  • First, select the data range that you want to use for the second graph. This data can be from a different range on the same worksheet or from a different worksheet altogether.
  • To select the data, click and drag to highlight the cells that contain the data for the second graph.

B. Choose the appropriate chart type
  • After selecting the data, go to the "Insert" tab on the Excel ribbon.
  • Click on the "Recommended Charts" option to see a list of chart types that Excel suggests for your selected data.
  • If you have a specific chart type in mind, you can also choose it from the "Charts" group on the "Insert" tab.

C. Customize the chart to ensure it complements the first graph
  • Once the chart is inserted, you can customize it to ensure it complements the first graph and effectively conveys your data.
  • Adjust the chart title, axis labels, and legend as needed to make the second graph visually coherent with the first one.
  • You can also change the chart style, color, and other formatting options to differentiate it from the first graph while maintaining a cohesive visual presentation.


Arranging the graphs on the same sheet


When working with multiple graphs in Excel, it may be necessary to put them together on the same sheet for better comparison and analysis. Here’s how you can easily arrange the graphs on the same sheet:

A. Insert a new worksheet or locate an existing one

If you are working with a new workbook, insert a new worksheet by clicking on the plus sign at the bottom of the screen. If you are working with an existing workbook, locate the worksheet where you want to place the graphs.

B. Copy and paste the first graph onto the new sheet

Click on the graph you want to move, then right-click and select “Copy” from the menu. Next, go to the new worksheet, right-click on an empty cell, and select “Paste” to place the graph on the sheet.

C. Position the second graph next to the first one

Now that you have the first graph on the new sheet, you can easily position the second graph next to it. Click on the second graph, then right-click and select “Copy.” Go to the new worksheet, right-click on an empty cell next to the first graph, and select “Paste” to place the second graph next to the first one.


Linking the graphs


When putting two graphs together in Excel, it is important to ensure that they are linked visually and contextually. This can be achieved by adjusting the axis and scales and adding necessary labels or titles.

A. Adjust the axis and scales to ensure consistency between the two graphs
  • Ensure that the range of values on the y-axis of both graphs are consistent and aligned. This will allow for an accurate comparison between the two sets of data.

  • Adjust the scale of the x-axis to match if the graphs are representing the same set of data over a specific time frame. This will help in maintaining consistency and making comparisons easier for the audience.

  • Consider if the graphs require the same gridlines or major units for a clearer visual connection between them.


B. Add any necessary labels or titles to clarify the relationship between the two graphs
  • Add a title that clearly explains the connection between the two graphs. This will help the audience understand the relationship between the data being presented.

  • Include consistent labels for the x and y-axes of both graphs. This will aid in understanding the data being depicted and make it easier for the audience to compare the graphs.

  • Consider using a legend if the graphs contain different data series. This can help in differentiating the data and understanding the relationship between the graphs.



Conclusion


Combining two graphs in Excel is a simple process that can greatly enhance your data presentations. First, select the data sets for both graphs. Then, create the first graph, and add the second data set to it by selecting the data and choosing the chart type. The benefits of visually representing data in this way include providing a more comprehensive and comparative view of the data, making it easier for your audience to understand and interpret. I encourage you to practice combining graphs in Excel to improve the visual representation of your data and make your presentations more impactful.

Excel Dashboard

ONLY $99
ULTIMATE EXCEL DASHBOARDS BUNDLE

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles