how to create percentage pie chart in excel

Recording a macro I see that the NumberFormat for dot as thousands separator is: _-* #,#0_-* #,#0_- _-* but I cannot format the DataLabels with it since then the percentage won't show up correctly. Note: Pie charts can also be used as a mark type in a visualization.įor more information, see Pie mark.I'm trying to format the DataLabel of a chart with thousands separator (dot) and two decimals in the percentage. 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.

How to create percentage pie chart in excel