how to make a pie chart in excel with multiple columns

Step 1: Scan to select the data area to insert the chart. Draw a chart containing basic data before combining columns and lines in excel It looks difficult but it is really easy, just follow the following steps: 1. Specifically as in the following picture:ĭraw a combination of columns and lines in Excel Or more advanced, you might want the revenue to be represented by columns, and the costs shown by This is a convenient way to track, meaning you want to apply a chart to combine columns and lines in Excel. But here if you want to show all revenue and expenses, you have to split them into two vertical axes Y.

Here if you draw charts and graphs in excel, the X-axis can be from January to December, while the vertical Y axis will be the revenue or expense column. Take a specific illustration with a graph that tracks both revenue and expense at the same time for 12 months.Īn example of a chart containing column and line data combined in excelįirst, TipsMake has an example, you have an excel statistics table of revenue and expenses from January 2015 to December 2015, for example. Because many questions have been asked about how to create a combination of columns and lines in Excel, TipsMake today will guide you how to create a combination of columns and lines in excel.

How to make a pie chart in excel with multiple columns