If you have Gender column in your sheet which have values "Male", "Female" for every row - how to create a PIe Chart?
In Google sheets it just takes couple of clicks and quite intuitive.
Here is how to do it in Excel:
1. Select the column
2. Insert Tab - Click PivotChart - OK
3. In PivotChart Fields select and drag that column to all sections.
4. Now you have Clustered Column chart.
5. Right click the chart -> Change Chart Type -> Pie -> Ok
No comments:
Post a Comment