create pie chart in excel on mac with one column

You can change the line color and column bar colors according to your wish. Step 11: It will give us the below combination chart. Step 10: In the same window, change the chart type of both COGS & Profit to Line chart as shown in the below image. (Excel must have selected this option by default). Step 9: Now, you will see the Change Chart Type dialogue box. Right-click and select Change Series Chart Type. Step 7: Now, your chart should look like this. Step 6: Select the Year list here. Click on OK to complete the process. Step 5: Now click on EDIT on the right-hand side, i.e. Step 4: Firstly, remove Year from the below window. Step 3: Right-click on the chart and select Select Data. Step 2: Now, your chart should look like this.

Step 1: Select the entire data range and insert a simple column chart. In order to create an excel combination chart, I have a few years’ sales, cost, and profit data in an excel sheet. You can download this Combination Chart Excel Template here – Combination Chart Excel Template Excel Combo Chart – Example #1

Create pie chart in excel on mac with one column