Question

You set up a pivot table for sales by product over the last three years and add an easy-to-read, 100% stacked bar chart. Why would you also include an order date slicer?

a) To sort products alphabetically
b) To filter sales data by year
c) To rearrange the chart layout
d) To adjust the color scheme

Answer 1

An order date slicer is used to filter sales data by year in a pivot table with a 100% stacked bar chart, allowing for the analysis of sales trends over specific time periods.

Step-by-step explanation:

You would include an order date slicer in a pivot table showing sales by product over the last three years with a 100% stacked bar chart mainly to filter sales data by year. This enables you to analyze how sales trends change over time. For example, you could use the slicer to display only the data from the previous year, thereby helping you to focus on more recent sales data, see patterns or trends, and make data-driven decisions. Conversely, these presentation choices in other contexts, such as a pie chart or bar graph, influence the interpretation by how we choose to show the data — the categorization of data in pie charts or the scale of the axis in bar graphs, for example, can significantly affect how information is perceived.