+4 votes
2 views
How to overlay charts in Microsoft Excel

ago in Guides by (472k points)
reopened ago | 2 views

1 Answer

+5 votes
Best answer

Create a combo chart in Excel
Set up a combo chart
Change chart
Create a chart

It's too easy to overlay charts in Microsoft Excel , although Microsoft's office application has a good selection of chart types, we may need something out of the ordinary. A graphic that that overlays may be what you need and a little further down we will show you how to apply it to your spreadsheet..

Create a combo chart in Excel

If we want to overlay charts in Microsoft Excel, a custom combo box is what you are looking for. You can combine cells and columns, bars, lines, areas, and various types of charts in a single image.

image

In the accompanying image, we have a column chart that allows us to see the sales of our two divisions along with the totals. As can be seen in the image, "Totals" appears out of place and does not allow the data to be displayed clearly..

If we use a custom combo chart, we can modify "totals" to a line in our column chart.

Change chart

image

If we already have a graphic which we want to change, we will have to select it and go to the "Graphic Design" tab. Then we will click on "Change Chart Type" on the right side of the ribbon..

image

Once we are in the "Change chart type" window, we are going to choose "Combo" found in the left sidebar and "Custom combination" on the right.

Create a chart

image

If we still do not have a chart, we will select our data and go to the "Insert" tab. In the “Charts” section of the ribbon, we will have to click on the drop-down arrow to Insert combo chart and select “Create custom combo chart”.

Set up a combo chart

If we have the Graph window open and the Custom Combination Table selected, then we can visualize the area with which we can work at the bottom.

image

Next to each data series, we can choose the type of graph that we can use in the drop-down box. We can also add a secondary axis for any of the series by checking the box on the right.

image

While we are making modifications, we can see a preview at the top to be able to change something if we want. Once we are satisfied, we will simply click "Accept".

image

In this way we have a combo chart that shows the divisions as columns and total data as a line. Obviously, this allows us to appreciate in a clearer way the data that we are trying to transmit.



ago by (3m points)
edited ago

Related questions

+3 votes
1 answer
asked 2 days ago in Guides by backtothefuture (472k points) | 3 views
+4 votes
1 answer
asked 4 days ago in Guides by backtothefuture (472k points) | 6 views
+5 votes
1 answer
asked Dec 26, 2021 in Guides by backtothefuture (472k points) | 2 views
+4 votes
1 answer
asked Dec 23, 2021 in Guides by backtothefuture (472k points) | 3 views
+3 votes
1 answer
asked Dec 22, 2021 in Guides by backtothefuture (472k points) | 6 views
9,071 questions
9,174 answers
416 comments
2 users