Column and bar charts in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Choosing the right chart type for sales data

You have monthly sales data for three products in Excel. You want to compare the sales of each product side by side for each month. Which chart type should you use?

A Clustered column chart

B Stacked column chart

C 100% stacked bar chart

D Pie chart

💡 Hint

Think about how to show each product's sales separately for each month.

A clustered column chart places columns for each product side by side for each month, making it easy to compare their sales directly. Stacked charts combine values, which can hide individual product sales. Pie charts show parts of a whole but not comparisons over time.

📊 Formula Result

intermediate

Effect of changing data on a bar chart

You have a horizontal bar chart linked to a data range A1:A5 with values {10, 20, 30, 40, 50}. If you change the value in cell A3 from 30 to 60, what will happen to the bar chart?

A The third bar will become twice as long as before

B The third bar will disappear

C All bars will become longer

D The chart will show an error

💡 Hint

Bar length corresponds to the value in the cell.

Changing the value in A3 from 30 to 60 doubles it, so the third bar's length doubles. Other bars remain unchanged.

❓ Function Choice

advanced

Which Excel feature helps add data labels to a column chart?

You created a column chart and want to display the exact values on top of each column. Which Excel feature should you use?

A Insert Trendline

B Add Data Labels

C Change Chart Type

D Format Axis

💡 Hint

Look for an option that shows values directly on the chart.

Adding data labels places the numeric values on each column, making the chart easier to read. Trendlines show trends, changing chart type changes the chart style, and formatting axis changes axis appearance.

❓ data_analysis

advanced

Interpreting a stacked column chart

You have a stacked column chart showing quarterly revenue for three regions. The total height of the Q2 column is 150, with segments 50, 60, and 40 from bottom to top. What is the revenue for the second region in Q2?

A 40

B 50

C 60

D 150

💡 Hint

Look at the middle segment's value in the stacked column.

The stacked column segments represent each region's revenue. The second region corresponds to the middle segment, which is 60.

🧠 Conceptual

expert

Understanding axis scaling in bar charts

You create a bar chart with values ranging from 0 to 1000. You notice the horizontal axis starts at 200 instead of 0. What is the likely reason for this behavior?

A Excel automatically hides values below 200

B The chart type does not support zero baseline

C The data contains negative values

D The axis minimum was manually set to 200

💡 Hint

Check axis formatting options.

Excel allows users to set axis minimum and maximum values manually. If the minimum is set to 200, the axis will start there instead of zero. Excel does not hide values automatically, and the chart type supports zero baseline.