how to make a pie chart in excel if it isnt working

On the current chart, it is labeled “Monthly”. The chart legend is the colored box and text that tells the reader what each color on the chart represents. Then set the pie chart to show the 'label' column you just created.Once you’ve created a chart, it’s likely that you’ll want to change the legend. Then set the pie chart to show the 'label' column you just wrote: It works the same way as it does in Excel: CSource_ & Char(10) & Text(countsource/CountRows(Case),'#.0') Use Text() to change how many decimals you want. If you want to show a percentage, you will divide by the number of all records: CSource_ & Char(10) & countsource/CountRows(Case) Edit the part in blue to what you would like. 'label', CSource_ & Char(10) & countsourceįrom here, format what you want to show in label. AddColumns(įilter(Case,ArrivalDate=DatePicker1.SelectedDate), Nest what you have inside another AddColumns formula. Normally you can add as many columns as you want inside one AddColumns formula. But since the next column relies on the value countsource, you will need to close off its calculation.

Unlike Excel, the pie chart object does not have a property for showing both the name of the slice and the number value for the slice, so you have to make it yourself. If you mean how do you show the count on the pie chart, you will need to add a helper column to show the actual text you want.

How can I add so the Chart shows the actual number of the items?

How to make a pie chart in excel if it isnt working