5 Replies Latest reply on Oct 25, 2018 4:27 PM by Zhouyi Zhang

# Create a bar chart with percentages and multiple measures

Hi,

This may be very simple, but I am not able to create a bar chart with the following characteristics:

The bar chart that I want to create should look like this:

---------------- 70% Instagram

------- 40% SnapChat

What I am getting is without percentages, but with count:

----------------- 14 Instagram

-------- 8 SnapChat

Or with all percentages equal to 100%

The data is formatted as follow:

SurveyUse Facebook (18 out of 20 use it)Use Instagram (14 out of 20 use it)Use SnapChat (8 out of 20 use it)

1

3InstagramSnapchat

If someone can help me with this, I would highly appreciate.

• ###### 1. Re: Create a bar chart with percentages and multiple measures

Hi, Erwin

Can you explain a bit more about how the % is calculated? e.g. 40% of snapchat.

ZZ

• ###### 2. Re: Create a bar chart with percentages and multiple measures

Hi ZZ,

Thanks for getting in touch. I hope I can answer your question here:

• The survey data set has 20 rows, besides the headers
• Each row represents a respondent
• There is one column header called "Use SnapChat"
• Below that header, 8 out of 20 cells (40%) are filled with the word "SnapChat," as 8 people, from the survey sample, responded that they use Snapchat
• There are people who use SnapChat, Facebook and Instagram
• Other people use only two of the 3 social media services
• Others use just one
• And some, none
• So there is one column to count the respondents who use Facebook, another column for those who use Instagram, and one last column for those who use Snapchat
• The dataset should look like the one shown in my original question
• In a few words, the calculation is the number of filled cells divided by the total number of rows (either filled or empty - each row representing one survey respondent)

I hope this can help.

Best,

Erwin

• ###### 3. Re: Create a bar chart with percentages and multiple measures

Hi, Erwin

Please find my solution attached and the explain below for your reference.

I just use the 4 data rows you attached as example.

Hope this helps

ZZ

• ###### 4. Re: Create a bar chart with percentages and multiple measures

Thanks ZZ. I have a question. What is AGG(Calcul...? Where can I get it? I was able to create the Pivot Table and to get the three items together as a table but with no numbers.

Thanks,

Erwin

• ###### 5. Re: Create a bar chart with percentages and multiple measures

Hi, Erwin

That's the Calculation1 as I showed in my previous reply, you need create this and drag it to Text to show the figures.

ZZ