From spreadsheet cells to a finished bar graph
A clean paste starts with a rectangular table. Put category labels in the first column, such as Monday through Friday or the names of five materials. Put each measured series in its own column and give every column a short heading. A 5-row table with two value columns becomes 5 category groups, 10 possible bars, and a two-item legend.
Copy the cells with the heading row included and paste them into the box. Spreadsheet applications normally copy cells with tabs between columns, which this tool reads directly. Comma-separated values work too, and quoted text protects a category such as Museum, east wing from being split at its comma.
- Empty row: ignored, with no fake zero added.
- Blank value: that series has no bar for the category.
- Text in a value cell: marked in red, named in a data note, and not plotted.
- Missing category label: kept as Row 1, Row 2, or its actual row number so a real measurement is not silently discarded.
Read the notes before exporting. They are a short audit trail of what the graph did with awkward cells, which is more useful in a science lesson than quietly converting bad input into zero.
