Question 23

Explanation

To track the progress of sales revenue that is realized versus the target, the most suitable chart type would be: B. Flat Gauge A flat gauge chart is particularly effective for displaying performance against a target. It visually represents the actual value (such as realized sales revenue) in comparison to a pre-defined target value, making it easy to see at a glance how close the actual performance is to the goal. This type of chart is ideal for tracking progress towards a target and is commonly used in sales and financial reporting to quickly convey the status of key metrics against objectives. The other chart types have different typical uses: A. Bar Chart While bar charts are versatile and can be used to compare different categories or track changes over time, they are not the most effective for directly comparing a single metric against a target. Bar charts are better suited for displaying and comparing discrete values across categories or time periods. C. Pivot Table A pivot table is a data summarization tool that is more about organizing and grouping data than visually representing progress against a target. It's useful for detailed data analysis and exploring different dimensions of data, but it does not provide the immediate visual impact needed for quickly assessing performance against a target. D. Pie Chart Pie charts are good for showing the proportion of parts to a whole, but they are not ideal for tracking progress against a specific target. They lack the clarity needed to show how close a value is to reaching a predetermined target. So, the flat gauge chart (option B) is the most appropriate choice for visually representing and tracking the progress of sales revenue against a target. It provides a clear and immediate understanding of how the realized revenue compares to the sales target.