Step-by-step how to combine two charts in Excel

16
49950
Step by step how to combine two graphs in Excel
Excel Spreadsheets

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.

Business Spreadsheets

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.

Step by step how to combine two graphs in Excel

2 - Click on the table. Then, on the Insert menu, click in the arrow at the bottom corner of the insert data block.

Step by step how to combine two graphs in Excel

Business Spreadsheets

3 - In the Insert Chart window, select Column, and then the Clustered Column template.

Step by step how to combine two graphs in Excel

4 - In the inserted chart, you must click on the bar that corresponds to the profit (third variable).

Step by step how to combine two graphs in Excel

5 - In the Design menu, select the Change Chart Type option.

Step by step how to combine two graphs in Excel

Business Spreadsheets

6 - In the open window, select the Combo option, and next select Cluster Column - Line.

Step by step how to combine two graphs in Excel

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!

Step by step how to combine two graphs in Excel

Business Spreadsheets
Are you in doubt? Get in on LUZ Excel Forum and send your question!

Excel Spreadsheets

16 COMMENTS

  1. Hi Geise, one possibility is to reduce the amount of graphics talking about them in the text and putting them in the attachment, so as not to take up CBT space itself. About bundling information on a single chart, it is quite possible as well, but be careful not to lose the sense of what you want to pass

  2. Hi Rafael, I'm finished with my TCC and I found a problem.
    I will have around 40 graphs “which is very much according to my advisor”, and I cannot unite two statements made to the employees of the company analyzed in the same graph. Can you help me?
    Thank you in advance.

  3. It is not possible to make a chart that has two types in the same series of data, but it is possible to “circumvent” this by creating a chart of one type for a quantity of data and another, of another type for the remaining quantity. Example
    - if I have 10 values ​​and I want 5 to be a column and 5 to be a row
    - I take these 10 values ​​and separate them into two lines, the first would be xyzwk 0 0 0 0 0 and the second would be 0 0 0 0 0 XNUMX abcde

  4. Hello!
    I'm trying to make a chart that starts with one model and ends in another. Do you know if this is possible?

  5. Hi Edicleiton, I believe it is possible, you just need to adjust the data used in the chart. To make changing the chart type easy, just select the chart and go to the DESIGN tab (there you have the option to change the type)

  6. Hi Rafael,
    They have how to put in the same stacking chart and bar. Ex: the goal would be with bar graph and the one performed by the man and performed by the woman to be stacked with graphics all this per day on the x axis?

  7. Hi William, you can do this, just have 4 series on your chart and organize how each of them will be presented. The only risk is getting a little messy.

  8. Good!
    Doubt: can you include two lines, each referring to a specific column?
    Ex .: Revenue column with revenue percentage line ... Expense column with expense percentage line.

  9. Thank you Alcyane! A good tip I can give you is to upgrade your Excel to 2016, which has some extra features

  10. Hi Bruno,

    I use Excel 2013, so I do not know exactly all the features of 2010. But if you say you are not finding the combo option it is very likely that it only appeared in Excel 2013.

    Anyway, even without this option I believe you can choose the series of data of interest and modify the type of chart. In the example of the post instead of you click combination, I would click on line chart, because that way, you would change the third series to not be more column and just turn line ok?

  11. My Excel 2010 does not have the combo option, only works from Excel 2013?

Comments are closed.