create pie chart in excel based on one column

Watch this video to see the steps to build a pie chart in Excel. So, if you’ve never built a pie chart in Excel, or it’s been so long that you’ve forgotten the steps, here’s how you can do the best job possible. Your sister needs help with a report for her dessert of the month club, and a pie chart seems okay for that!.Perhaps your professor is basing 50% of your final grade on building the perfect pie chart.Maybe your boss is demanding that you make one for the annual report.Why would you want to make a pie chart? It could be one of these reasons: No, it might not be the best way to present your data, but sometimes you have to go with the chart type that someone else chooses. Note: Pie charts can also be used as a mark type in a visualization.įor more information, see Pie mark.Sometimes, you need to make a pie chart in Excel. For more information, see Actions and Dashboards. You can make a pie chart interactive in a dashboard. If you don't see labels, press Ctrl + Shift + B (press ñ + z + B on a Mac) to make sure most of the individual labels are visible. Add labels by dragging the Sub-Category dimension from the Data pane to Label on the Marks card.To make the chart bigger, hold down Ctrl + Shift (hold down ñ + z on a Mac) and press B several times. Aggregate fields, such as Profit Ratio, don't contribute to those requirements. Pie charts require at least one or more dimensions and one or two measures. Click Show Me on the toolbar, then select the pie chart type.

By default, Tableau displays a bar chart.

Tableau aggregates the Sales measure as a sum.

Drag the Sales measure to Columns and drag the Sub-Category dimension to Rows.

Connect to the Sample - Superstore data source.

To create a pie chart view that shows how different product categories contribute to total sales, follow these steps: The basic building blocks for a pie chart are as follows: Use pie charts to show proportions of a whole.

Create pie chart in excel based on one column