Now for profit and market share, change the chart type to the line with markers and tick the secondary axis for both.Ĭongratulations! your interactive chart is ready to rock.Go to Design Tab ➜ Design ➜ Change Chart Type. After that, select your data bars & click on “change chart type”.

First of all, select your table and insert a column chart.

Now, you can control your data with these option buttons.

In format control options, link it to the cell A1 and click OK.

After that, right-click on any of the buttons and select “format control”.

Insert three option buttons and name them as following.

Go to developer tab ➜ Control ➜ Insert ➜ Option button.

For “2” it will show profit and market share for “3”.

And when you enter “1” in the A1 table will show you data for target and achievement only. Our team and other members will provide answers as quickly as possible.įor more Windows guides visit our Windows How To page.All the cells in this table are linked with A1. If you did, please spare a few minutes to share your thoughts with Itechguides Community Forum.įurthermore, if you have any questions, comments, or feedback please them to Itechguides Community Forum. Then move your pie chart away from your data.Finally, click the x sign on top of the chart insert tool to close it.If you wish to customize the chart, click the Customize tab (see the image below).To change the chart type to Pie chart, click the drop-down arrow beside Line chart (see the image below). When you click Chart, Google Sheets will select Line chart by default.Highlight all the data including the headers.Here are the detailed steps to create a pie chart in Google Sheets: I will use the data in the Google Sheets shown below to demo how to create pie chart in Google Sheets.

Just like excel you can also create a Pie chart in Google Sheets. How to Create a Pie Chart in Google Sheets

Once you select a pie chart type, the chart will display on the data.

Excel also supports two other types of Pie charts – 3-D pie chart or Doughnut pie.

How do i create pie chart in excel