Better way to represent a survey response sheet result with over total

Question

What is better way to represent survey result with over total? What are the possible ways to denote such data?

Answer 1

Hi Banu,

Some of the ways to represent survey data:

1. Dual axis chart.

2. Pie/ Donut chart

3. Lod expressions

4. Reference lines.

Depending on the amount and type of data you should choose,

Pie/ Donut is used when the data used to compare are same or of lesser variety and types and less data.

Dual axis chart is better used for clear and better understanding of data comparison of any amount of data and type of data.

Lod expressions can be used to show to show total or fixed values for survey/measure.

Reference lines are used to show line to show total vs filtered in form of lines over bar chart or column chart.