Superimposing Two Charts in Excel: A Step-by-step Guide
Are you struggling to create a clear and comprehensible chart in Excel that allows for the comparison of two different data sets? Do you want to superimpose two charts in one graphic representation? You’re not alone! Many Excel users face this challenge, but it’s easier than you think. In this article, we’ll show you how to superimpose two charts in Excel, using a practical example that will make it easy to understand.
The Challenge of Superimposing Two Charts
Superimposing two charts in Excel may seem like a complex task, but it’s actually quite straightforward. The key is to create a chart with multiple data sets and then customize the appearance to make it clear and comprehensible.
Step 1: Prepare Your Data
To superimpose two charts, you’ll need to have two sets of data in Excel. This can be in the form of columns or rows, depending on your preference. For this example, we’ll use columns for the “Entrances” and “Gone Out” data.
Step 2: Create a Chart With Multiple Data Sets
To create a chart that displays both data sets, follow these steps:
- Select the entire column (A) where you have the data.
- Go to the “Insert” tab in Excel and select the type of chart you want to use. For this example, we’ll use an istogramma (bar chart).
- Click on the chart icon to insert it into your worksheet.
Step 3: Customize Your Chart
To make your chart clear and comprehensible, follow these steps:
- Select the data that you want to represent with a different type of chart (in our case, “Entrances”).
- Go to the “Design” tab in Excel and click on the “Change Chart Type” button.
- In the window that opens, select the type of secondary chart you want to create (in this case, lines with indicators).
- Click OK to save your changes.
Step 4: Superimpose Your Two Charts
To superimpose your two charts, follow these steps:
- Select the secondary chart you created in Step 3.
- Go to the “Format” tab in Excel and click on the “Selection” button.
- In the window that opens, select the “As Secondary Axis” option.
- Click OK to save your changes.
Step 5: Finalize Your Chart
To make your chart more visually appealing, follow these steps:
- Select your chart and go to the “Design” tab in Excel.
- Select a visual style from the menu graphic styles to render it clear and captivating.
And that’s it! You now have two charts superimposed in one graphic representation. This is just one example of how you can superimpose two charts in Excel. The steps are similar for other types of charts, such as columns or lines.
Superimposing Two Charts in Libreoffice
If you don’t want to pay a monthly subscription or license fee for Microsoft Excel, you can use LibreOffice instead. It’s a free and open-source alternative that also allows you to superimpose two charts.
To do this in LibreOffice Calc:
- Open your spreadsheet.
- Select the data you want to display in your chart.
- Go to the “Insert” menu and select “Chart”.
- Choose the type of chart you want to create.
- Customize your chart as desired.
- To superimpose a second chart, follow the same steps as above.
Superimposing Two Charts in Google Drive
If you don’t have Excel on your computer or prefer to use a cloud-based service, you can use Google Drive instead. It’s free and allows you to create and edit spreadsheets directly from your browser.
To superimpose two charts in Google Drive:
- Open the Google Drive website.
- Sign in with your account.
- Choose to upload an existing spreadsheet file or create a new one.
- Select the data you want to display in your chart.
- Go to the “Insert” menu and select “Chart”.
- Customize your chart as desired.
Conclusion
Superimposing two charts in Excel is easier than you think. With these steps, you can create a clear and comprehensible chart that allows for the comparison of two different data sets. Whether you use Microsoft Excel, LibreOffice, or Google Drive, this guide has shown you how to superimpose two charts using simple and practical examples.
Frequently Asked Questions
Q: What is the difference between superimposing two charts and creating a single chart with multiple data sets?
A: Superimposing two charts involves creating two separate charts that are placed on top of each other, whereas creating a single chart with multiple data sets involves combining all your data into one chart.
Q: Can I use this method to create a chart with more than two data sets?
A: Yes! The steps outlined above can be adapted for any number of data sets you want to display in your chart.
Q: How do I customize my chart further?
A: You can add more details, such as labels or colors, by selecting the “Format” tab and clicking on the “Selection” button.
Q: Can I save my spreadsheet with multiple charts online?
A: Yes! Google Drive allows you to upload your spreadsheet directly from your browser and share it with others.




