Serial Chart Labeling Issue (Percentages)

Question

Hi All,

I've created a serial chart with Percents along the Y-axis (and Dates on the X-axis), but I've run into an issue when trying to add a percent symbol to the labels.

I'd like to add the "%" symbol to the end of the Labels Pattern (under the Value Axis tab) without causing the values to be multiplied by 100.  (My data was entered as integers, not decimals)

Option 1: Using "#" adds a # symbol to the popup and axis values, but it multiplies the values by 100.

Option 2: Using "%" HTML decimal encoding (or Hexadecimal) adds a # symbol to the popup, but it displays as "&#37" on the axis values.

Is there a workaround for this issue?

EllieLinden · Answer

Has there been a solution for this? I’m running into the same problem where I’d like the % to appear as the suffix for the x-axis labels, while setting “sq km” as the suffix for the hover values. When I add “sq km” as the hover suffix, it also incorrectly adds it to a suffix in the x-axis.

SerialChart_HoverAxisUnits.jpg

ahargreaves_FW · Answer

I think I have the same issue that apparently still hasn't been rectified, namely: When attempting to add a "%" label to a serial chart value column the current value is just multiplied by 100. See below for decimal values vs percentages. But my values aren't decimals, they're the count of grouped records:

Data is set up to show counts of the same record status

It's not decimals, though that works as a display option

'percent' simply multiplies by 100

Caro_Dono · Answer

I am also frustrated by this.  Has anyone figured out a solution?