Start with the question, not the chart
Before opening a chart menu, decide what you want someone to learn. Are you comparing attendance at several activities, showing how a figure changed month by month, or showing how a total is divided? Write the question in a sentence. It will guide both the data you select and the type of chart you make.
Keep the chart focused on one main point. A table can hold many details, but a chart becomes harder to read when it tries to show every column at once. If you are comparing monthly totals, for example, select the month names and totals rather than including unrelated notes from the same sheet. You can leave the full table available for readers who need the detail.
Prepare the spreadsheet cells
Put clear column headings in the first row of the data you plan to chart, such as Month and Number of visits. Place each observation on its own row. Keep dates, categories and numbers in separate columns, and use a consistent unit for every value in a series. Check that numbers are stored as numbers rather than text; a spreadsheet may treat an entry with an extra space or symbol differently from the rest.
Look for blank cells, repeated rows and totals mixed into the observations. A blank cell might mean zero, or it might mean that no figure was recorded. Do not replace it with zero unless zero is what the data means. Likewise, a total row can distort a chart of individual categories if you select it by accident. Save a copy of the original data before making substantial changes, so you can check your work later.
Select only the cells needed for the chart, including their headings. Most spreadsheet programs offer an Insert or Chart command and then a preview. If the preview groups values incorrectly, check whether the program has treated rows as series when you intended columns, or the other way around.
Choose a chart that fits the comparison
Use a bar or column chart when comparing distinct categories, such as visits to different service locations. Bars are often easier to label when category names are long. Use a line chart when showing change across ordered points in time, such as monthly totals. The order matters: sorting months by their values instead of by date would give a misleading picture of the trend.
A pie chart can show parts of one whole, but it is usually difficult to read when there are many slices or small differences between them. A bar chart may make those comparisons clearer. If you want to show two different measures, consider making two simple charts rather than squeezing both into one. The best choice is the one that lets a reader answer your original question without having to decode the design.
Make the meaning easy to read
Replace a generic chart title with one that says what the chart shows, such as Monthly visits to the community centre. Label axes when their meaning is not obvious, and include units such as people, hours or pounds. Use category names that readers will recognize. If the chart has more than one data series, give each a clear name in the legend.
Check the scale before sharing. For a bar chart, starting the value axis above zero can make small differences look much larger than they are. Line charts may use a narrower scale to show change, but the axis should still be visible and easy to interpret. Avoid three-dimensional effects and unnecessary decoration: they can make values harder to compare.
Use colour sparingly and make sure the chart still makes sense without relying on colour alone. Distinct labels, line styles or direct value labels can help. If you add data labels, check that they do not overlap or turn the chart into a crowded table.
Check and share the finished chart
Compare the finished chart with the spreadsheet. Are the categories in the intended order? Are any values missing? Does the title match the selected data? Ask someone unfamiliar with the sheet what they think the chart shows. If their answer differs from yours, clearer labels or a simpler chart may help.
When sharing a chart in a document or online, add a short text description of its main point and keep the underlying figures available in a readable table when practical. This helps people who cannot easily use the visual chart and gives everyone a way to check exact values. If the spreadsheet contains personal or sensitive information, share only the data needed to explain the result, and inspect any attached file for details you did not intend to include.
