Darren wants to create a single large chart that shows how two of his competitors are

Question

performing over time—tracking their relative proportion of the total market share. What type of
chart is especially suited to this?

PivotTable
line chart
pie chart
Sparkline

Answer 1

For tracking the relative proportion of market share over time for two competitors, a line chart is especially suited. Line charts are effective for displaying trends over time, allowing for the comparison of multiple data series and providing a clear visual representation of changes in market share for each competitor.

In contrast, a pie chart is best for showing parts of a whole at a single point in time, while PivotTables and Sparklines serve different purposes that may not capture the time-series aspect as effectively as a line chart.