AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.7K members online now
3.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Creating Pie Chart to show number instead of percentage

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want to be able to show the number field of my pie chart rather than the percentage this number represents.

 
Example:
Table: Red (5), Blue (4), Green (3)
 
Shows - Percentage of the sum Red (42%), Blue (33%), Green (25%)
Want to show - The actual number Red (5), Blue (4), Green (3) in the pie slice.
 
Any help appreciated. I have been struggling with this for hours.
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Pranshu S
May 2017

Re: Creating Pie Chart to show number instead of percentage

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Pranshu S

 

Not certain, changing the label type to 'value' should achieve this. See below:

 

 2017-05-24_14-10-49.png

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Pranshu S
May 2017

Re: Creating Pie Chart to show number instead of percentage

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Pranshu S

 

Not certain, changing the label type to 'value' should achieve this. See below:

 

 2017-05-24_14-10-49.png

Creating Pie Chart to show number instead of percentage

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks a lot @Ben P ... I was constantly changing the data types in original data sheets instead of exploring the STYLE tab. This is exactly what I needed Smiley Happy 

Creating Pie Chart to show number instead of percentage

Explorer ✭ ✭ ✭
# 4
Explorer ✭ ✭ ✭

Excellent - happy to help!