Excel Data Visualization: Basic and Advanced Charts, Chapters 43–44

What are the main types of charts available in Excel?

Column, Bar, Line, Combination, Scatterplots, Pie.

What is a clustered column chart?

A chart that displays multiple data series side-by-side within each category for direct comparison of actual values.

What does a 100% stacked column chart show?

It shows the percentage contribution of each category or series within each column, scaled to 100%.

What is the horizontal version of a column chart called?

Bar chart.

What is the purpose of a waterfall chart?

To visualize the cumulative effect of sequentially introduced positive or negative values.

What is another name for a waterfall chart?

Flying bricks chart or Mario chart.

What is a funnel chart used for?

Mapping process flows and conducting attribution analysis.

What is a Gantt chart primarily used for?

Project Management scheduling.

Who popularized the Gantt chart?

Henry Gantt.

What is the purpose of inserting a vertical line in a chart?

To highlight a specific point or to show a before and after comparison.

What are the five principles of good graph design?

Show data clearly, use simplicity in design, align on a common scale, keep visual encoding transparent, and use standard forms.

What are outliers in data visualization?

Extreme values that can be visualized to understand their impact on data.

How can outliers be visualized in a graph?

By comparing them to the mean and using standard deviation metrics.

What is a tornado chart used for?

To analyze which variables are most important in driving results.

What is the first step to create a Gantt chart in Excel?

Select the Column chart category and insert a Stacked Bar chart.

What is the purpose of manual adjustment in creating a Gantt chart?

To make the first part of the bar invisible for better visualization.

What is the significance of keeping graphs clear and simple?

To ensure that data points are easily seen and understood.

What is a combination chart in Excel?

A chart that combines two or more different types of charts to display data in a more informative way.

What is the purpose of using alignment on a common scale in graph design?

To ensure that comparisons between different data sets are meaningful and accurate.

What does 'visual encoding' refer to in graph design?

The way data is represented visually, which should be kept transparent for clarity.

What is the function of a scatterplot?

To show the relationship between two numerical variables.

What is the recommended way to insert a waterfall chart in Excel?

Use the Insert menu and select Waterfall.