Forum Discussion

Anonymous

Not applicable

4 years ago

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

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 th...

Super User

4 years ago

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

Anonymous
Not applicable
4 years ago
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
  Community Support
  4 years ago
  Hi, Anonymous
  
  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
  - Anonymous
    Not applicable
    4 years ago
    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