You have monthly sales data for three products in a Google Sheet. You want to compare the sales trends over time clearly. Which chart type in the Chart editor panel is best for this?
Think about which chart shows changes over time for multiple series.
A line chart connects data points over time, making it easy to see trends for each product. Pie charts show parts of a whole at one time point, scatter charts show relationships between two variables, and histograms show data distribution.
You create a chart from a data range with sales for all regions. In the Chart editor panel, you apply a filter to show only sales greater than 1000. What happens to the chart?
Filters in the Chart editor panel limit which data points are included.
Applying a filter in the Chart editor panel removes data points that don't meet the condition, so only sales above 1000 appear in the chart.
You want to show exact sales numbers on each bar in a bar chart. Which option in the Chart editor panel lets you add these data labels?
Look for options that control the appearance of the data points themselves.
Data labels are added under Customize > Series > Data labels in the Chart editor panel. This shows values directly on the chart bars.
You create a scatter chart in Google Sheets. In the Chart editor panel, you set the horizontal axis minimum to 0 and maximum to 100. What effect does this have on the chart?
Think about what setting axis minimum and maximum does to the visible data range.
Setting axis min and max fixes the axis scale. Data points outside 0 to 100 on the horizontal axis will not be shown or will be clipped.
In the Chart editor panel, you enable aggregation for a column of sales data. What is the main effect of this setting on the chart?
Aggregation means grouping or summarizing data.
Aggregation combines data points by calculating a summary statistic such as sum or average, reducing many values into one for clearer visualization.