Microsoft Excel brings a series of tools and facilities to facilitate the management of your business. It is common to see managers demonstrating their financial gains from charts in Excel. It turns out that the more data and information in a chart, the more difficult it can be to visualize.
So there is a very good way to display information in Excel using the combination of two charts. The visualization of 3 variables is very easy from this combination. Check out the step by step how to combine two graphs into one:
Step by step how to combine two charts
1 - Create your table with the data you want to combine. Our table example is very simple, we will combine revenue, expenses and profit.
2 - Click on the table. Then, on the Insert menu, click in the arrow at the bottom corner of the insert data block.
3 - In the Insert Chart window, select Column, and then the Clustered Column template.
4 - In the inserted chart, you must click on the bar that corresponds to the profit (third variable).
5 - In the Design menu, select the Change Chart Type option.
6 - In the open window, select the Combo option, and next select Cluster Column - Line.
That's it! Your combined chart is done! You can create combined charts with other metrics from your business, such as your website audience and bounce rate. Have you ever used charts combination? Share your experience with us in the comment session!
Are you in doubt? Get in on LUZ Excel Forum and send your question!