Chart Format - Percentage

Drew Goddin shared this question 4 weeks ago
Answered

I've formatted a data column as a percentage and it looks fine. When I graph the value it defaults back to the decimal and the vertical access shows 0.XX. Is there a formatting option I'm missing?

Comments (6)

photo
1

Hi Drew,

Thanks for reaching out. It's possible something is being missed, but I require more info to provide further support: What chart type are you trying to use? When you say you have a data column formatted as a percentage, do you mean you have Format under Display set to Numeric, set Decimal to 0, and have Suffix as %, like so:

/AfHb8VKDp2YXAAAAAElFTkSuQmCC

Or do you mean you have the Format set to Percentage?

/fuHUxxlZWABCQgAQlIQAISkMCwBaZNmzbsOvxsNtvZYdeiCiQgAQlIQAISkIAEJDCCBTS9YQRfHIUmAQlIQAISkIAEJOAbASW9vnFULRKQgAQkIAEJSEACI1hASe8IvjgKTQISkIAEJCABCUjANwJKen3jqFokIAEJSEACEpCABEawwP8PeJ4rwXhDe3sAAAAASUVORK5CYII=

Thanks,

Mike

photo
1

Mike, I have the later ... Format Percentage and then when I create a line graph it doesn't carry the formatting over. I'm trying to get away with not having to multiply the column by 100 to get the format on vertical axis correct. I'm hoping there is a simple answer that I'm overlooking. thanks.

photo
1

Visual of the issue


/ZtKWZK2EwP8DhkMW1CKCcqYAAAAASUVORK5CYII=

photo
1

Hi Drew,

Thanks for your response. Please head into the Axis settings and choose the Vertical axis and add "%" as the Suffix:

/J2z4P8YWLxAydKYbAAAAAElFTkSuQmCC

/Ju7nVJofuPBfTWJx5L+alK7wR3x4DH8dxuuvv55uCNpAwFUC+Byjq7ixGAiAgAoEkEqrECXYCAIg4CoBCKOruLEYCICACgQgjCpECTaCAAi4SgDC6CpuLAYCIKACAQijClGCjSAAAq4SgDC6ihuLgQAIqEAAwqhClGAjCICAqwQgjK7ixmIgAAIqEIAwqhAl2AgCIOAqAQijq7ixGAiAgAoEIIwqRAk2ggAIuEoAwugqbiwGAiCgAgEIowpRgo0gAAKuEoAwuoobi4EACKhA4P8Dw2OOo6K64RkAAAAASUVORK5CYII=

It depends on your data set and how you'd like your chart to display in considering whether you'll need to multiply by 100. The chart follows the underlying data, not the formatting, and it appears that 1 is the baseline here. If you want it to appear as 100 in your chart if that assumption is correct, then yes you'll need to multiply by creating a calculated field based off that data. Please let me know if you have any further questions.

Regards,

Mike

photo
photo
1

Hi Drew,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Drew,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you yet, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike