create a graph to show differences between two graphs/data sets

[Aladris]

I have recently created a survey and now creating a report to analyze the results and visualize it for top management.

I have one question with simple yes or no answers and a pie chart to show the percentage lets say 90 % people know about the tool we are making the survey about.

and I have a following question related to if people know how to use the tool with yes or no answers and the pie chart to show the results and lets say it is %20.

my problem is how can I create a third graph/chart to show that there is a %20 difference between people who knows the tool and but doesnt know how to use it.

thanks and regards

Gokhan

[amitchandak]

@Aladris , Pie visual Allow Details other than the legend that you can use. Or try 100% stacked bar visual

[Aladris]

@amitchandak thanks a lot for your answer. the thing is the difference is not on a data field. I just have colun on excel says yes or no for graph one tool awareness. and one column for tool knowledge again yes or no answers.

do I need a meaure to calculate the count of yes and no answers in each columns to a third column to use it on the next graph?

[v-easonf-msft]

Hi, @Aladris 

Yes, I think you do need to add other measures to calculate the count, if possible please provide sample data for research.

Best Regards,
Community Support Team _ Eason

[Aladris]

Hi @v-easonf-msft 

of course sample data set is like this, bot columns have same number of rows(users) as this is a survey.

column1          column2

yes                     yes

yes                     yes

yes                     yes

yes                     no

no                      no

so when i put these in two different pie charts I see that first column1 chart has %80 yes and %20 no and column2 is %60 yes and %40 no.

what I would like to calculate  is the difference of yes counts to show that 80% of people know about the tool but %60 of them knows how to use it so we have %20 missing training on how to use the tool. 

thanks for your help and regards