How can I round the values that are displayed on a Report or Chart?

Laura Solkowitz

I am using Reports to create Charts (specifically Pie & Stacked Bar) for a presentation.

I want each segment labeled with its value, but I would prefer that it be rounded to 1 or 2 places.

Currently the values go out like 7 places and do not fit on my charts neatly.

Thank you.

Melissa Yamada

Hello @Laura Solkowitz

You need to make the changes on the source sheet of your reports and make sure your data were rounded already since the report is only a visual representation of your sheet.

Laura Solkowitz

@Melissa Yamada the numbers are created by a report. Is there a way to round them from here?

Melissa Yamada

@Laura Solkowitz nope. Rounding off on the report isn't currently a feature on reports.

A possible solution for this is have your source sheet set with 1 decimal point. This way the Avg will be consistent in having 1 decimal point.