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

Question

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 · Answer

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

anonymous · Answer

amitchandak&nbsp;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.&nbsp;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?&nbsp;

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
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
&nbsp;

anonymous · Answer

Hi&nbsp;v-easonf-msft&nbsp;&nbsp;of course sample data set is like this, bot columns have same number of rows(users) as this is a survey.&nbsp;column1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column2yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yesyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yesyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yesyes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;nono&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; no&nbsp;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.&nbsp;what I would like to calculate&nbsp; 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.&nbsp;&nbsp;thanks for your help and regards&nbsp;&nbsp;

Forum Discussion

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

4 Replies

Related content

Graph showing data different from the data being inputted to the graph

Data Label on Graph

facing issue in the MS tutorial for data agent on Graph model

Graph not displaying data

Different schema into different destination