Selecting Data for Graphs and Charts
Data selection is the first step in creating a graph or chart. Data can be selected from contiguous ranges, where cells are adjacent (e.g., A1:A5), or from non-contiguous ranges, where cells or ranges are separated by other cells (e.g., A1:A3 and C1:C3). Specified ranges allow precise control over which data points are included.
Choosing the correct data range ensures the graph accurately represents the intended information. For example, if you want to compare sales figures for January to March, selecting only those months' data avoids misleading results.
- Contiguous ranges: adjacent cells, e.g., A1:A5.
- Non-contiguous ranges: separated cells or ranges, e.g., A1:A3 and C1:C3.
- Specified ranges: manually selected cells to include or exclude data points.
Choosing the Appropriate Graph or Chart Type
The type of graph or chart depends on the nature of the data and the message to be conveyed. Bar charts are ideal for comparing quantities across categories, line graphs show trends over time, and pie charts illustrate proportions within a whole.
For example, to show market share percentages, a pie chart is suitable because it visually represents parts of a whole. To compare monthly sales across different products, a bar chart or line graph is more effective.
- Bar charts: compare quantities across categories.
- Line graphs: display trends over time.
- Pie charts: show proportions or percentages of a whole.
Labeling Graphs and Charts Clearly
Labels provide clarity and context to graphs and charts. Essential labels include:
Chart title: describes the overall subject of the graph.
Legend: explains colours, patterns, or symbols used, especially when multiple data series exist, e.g., 'Product A' and 'Product B'. - Sector labels and values: in pie charts, these identify each slice and its numerical value or percentage, e.g., '30%'. - Axis titles: category axis (x-axis) and value axis (y-axis) titles explain what each axis represents, such as 'Months' and 'Sales (£)'. - Data value labels: show exact values on bars or points for precise interpretation.
- Add a descriptive chart title.
- Include a legend for multiple data series.
- Label pie chart sectors with values or percentages.
- Title both category and value axes.
- Display data value labels for clarity.
Adding a Second Data Series and Second Axis
When comparing two related but differently scaled data sets, adding a second data series and a second axis improves readability. For example, comparing monthly sales revenue (£) and units sold requires a second y-axis because the units differ.
To add a second data series, select additional data ranges and include them in the chart. Then, enable a secondary axis to plot the new data series with a different scale, ensuring both data sets are visible and comparable.
- Add multiple data series to compare datasets.
- Use a second axis when data scales differ significantly.
- Example: sales revenue (£) and units sold on separate y-axes.
Formatting Numerical Values and Adjusting Axis Scales
Formatting numbers enhances understanding. Set decimal places to control precision, e.g., two decimal places for currency values (£123.45). Add currency symbols where relevant to indicate monetary values.
Adjusting axis scales involves setting maximum, minimum, and increment values to display data clearly without distortion. For example, if sales range from £1000 to £5000, setting the y-axis minimum to £0 and maximum to £6000 with increments of £1000 provides a clear scale.
Proper formatting and scaling prevent misleading graphs and make data easier to interpret.
- Set decimal places for numerical precision.
- Add currency symbols for monetary data.
- Adjust axis maximum, minimum, and increments for clarity.
- Avoid misleading scales by choosing appropriate axis ranges.
Enhancing Graph and Chart Appearance
Visual appeal aids comprehension. Modify pie chart sectors by exploding slices to highlight specific data. Change colour schemes to differentiate data series clearly and use fill patterns for accessibility, such as for colour-blind viewers.
For example, use contrasting colours for different bars in a bar chart and apply patterns like stripes or dots if printing in black and white.
These enhancements make charts more engaging and easier to understand.
- Explode pie chart sectors to emphasise data.
- Use contrasting colours for clarity.
- Apply fill patterns for accessibility and print clarity.
At-a-glance summary
Comparison table
| Step | Detail | Example | Exam Use |
|---|---|---|---|
| Data Selection | Choose contiguous, non-contiguous, or specified ranges | Selecting A1:A5 vs A1:A3 and C1:C3 | Show ability to select correct data for graphing |
| Graph Type | Select bar, line, or pie chart based on data | Pie chart for market share, bar chart for sales comparison | Justify choice of graph type |
| Labeling | Add titles, legends, sector labels, axis titles | Chart title: 'Monthly Sales'; legend for products | Demonstrate clear and complete labeling |
| Additional Data | Add second data series and axis | Sales revenue and units sold with dual y-axes | Explain when and how to add multiple data series |
| Formatting | Set decimal places, currency symbols, axis scales | £123.45 with 2 decimals; y-axis 0 to 6000 in 1000 increments | Format numbers and scales accurately |
| Appearance | Modify colours, fill patterns, explode pie sectors | Use contrasting colours; explode a pie slice | Enhance chart readability and presentation |
Active recall
Quick check
1. What type of graph is best to show proportions of a whole?
A pie chart is best because it visually represents parts as percentages of the whole.
2. How do you include data from two separate, non-adjacent columns in a chart?
Select both non-contiguous ranges when creating the chart, using the control or command key to select multiple ranges.
3. Why add a second axis to a graph?
To display a second data series with a different scale or unit, making both data sets readable on the same chart.
4. What labels are essential for clarity in a bar chart comparing sales over months?
Chart title, legend (if multiple products), x-axis title (e.g., Months), y-axis title (e.g., Sales in £), and data value labels if needed.
5. How can you improve the visual appeal of a pie chart?
By exploding sectors to highlight parts, changing colours for contrast, and using fill patterns for accessibility.