Chart from table not showing all values

John Ientile

I am using Chart from table macro, however the pie chart is not showing all values, i.e. some values seems to be grouped together in a slice labeled as "Other".  Why is this the case and how can I configure it to show ALL values?.  Refer to attached screen shot.

Katerina Kovriga {Stiltsoft}

Hi @John Ientile ,

The Chart from Table macro aggregates the values that are less than 1% into the group "Other". The sectors are very small in this case, and you won't be able to define them and read their labels.

Unfortunately, you didn't attach your source table but I assume that you have a lot of values that are <1%, so they were combined into one big "Other" sector.

If this is the case but you still want to show all the values separately, please choose the "Column" or "Bar" graph type.