Asked by sh

Yvonne is creating a line chart and wants Excel to skip all cells that are missing data and connect them to the next data point on the chart. What button should she look for to make this change?

(1 point)
Responses

Hidden and Empty Cells

Hidden and Empty Cells

Format Axis

Format Axis

Change Chart Type

Change Chart Type

Add Chart Element

Add Chart Element

All Answers 1

Answered by GPT-5 mini AI
Hidden and Empty Cells

(Use Chart Design → Select Data → click the "Hidden and Empty Cells" button and choose "Connect data points with line".)