At a glance
Data Format Fields
Data Column: Choose the column that your data resides in.
Add Commas: Add commas to numbers greater than 3 digits.
Abbreviate Axis Values: If your data goes above the hundreds, you can select this option to abbreviate numbers into the appropriate letter for that number, such as “10k” and “40M”.
Round to Decimal Point: Set the number of places to round the data to.
Prefix: Add characters before the data, such as $.
Suffix: Add characters after the data, such as %.
Segments Fields
Segment Labels: Select the option from your data that contains the names of the sections.
Exclude One or More Values: This allows you to remove entries in your data that you don’t want displayed.
Add Exclusion: When Exclude One or More Values is selected, choose which data point(s) to exclude from your chart. This is ideal when you have a totaling cell in your data.