Timbral's plots turn rows of your spreadsheet into frequency-spectrum charts — or columns into charts that run down the rows, such as a time history — living in Plot panes alongside your sheets. Each Plot pane holds one chart.
What a plot is
A normal plot is a frequency-spectrum chart: the horizontal axis is frequency in Hz, and each spectrum row you select becomes one data series drawn across the frequency bands, and the vertical axis is whatever quantity those rows hold (dB by default, or the calculation's own quantity and unit). Frequencies of 1000 Hz and above are labelled "1k", "2k", and so on. (A Plot vertical chart works the other way round — see below.)
Creating a plot
- In a worksheet, select the rows you want to chart. Dragging across a sub-range of frequency columns plots only those bands; selecting a whole row (or a single cell) plots all bands.
- Open Plot ▾ in the ribbon's Plotting group and choose Plot spectrum. Each selected row that contains numeric band data becomes a series, labelled from its Item / Description text (or "Row N" if blank). If the selection has no numeric band data you'll see "No numeric band data in selection."
- Where the new series go: they merge into whichever Plot pane you most recently had focused — docked or popped out — so clicking back into the grid to pick more rows doesn't lose your place. If you haven't focused a Plot pane yet this session, a new Plot pane opens instead. Alt+click Plot spectrum to force a brand-new chart rather than merging into the last one you focused.
New series appear as lines with an automatically-assigned colour (the starting style for new charts and series can be changed in File › Options… › General › Plot defaults…). An empty pane shows "Select rows in a sheet and click Plot to create a chart."
Plot vertical: charting down the rows
To chart a column of values down its rows — a time history, say — select the cells and choose Plot ▾ › Plot vertical…. Each selected column becomes one series. Timbral asks one question: which column supplies the X-axis labels (Item by default, or Number the rows (1, 2, 3 …)). You can change that later in the chart's Axes tab, and each vertical series has a Rows to plot box in the Series tab, in Excel notation (for example H3:H20, or H3:H6, H10:H12 to skip rows). Alt+click works here too, to start a new chart.
Chart types
Each series can be drawn as, independently:
- Line (default) — with selectable thickness (1–5 px), dashes (solid, long or short dash), a smooth or straight curve, and markers;
- Bar — with selectable bar width, fill opacity and border;
- Scatter — with selectable point size (2–10 px) and marker shape.
Different series types can coexist on one chart (e.g. bars for a measured spectrum, a line for a target).
Customising the chart
Titles are edited on the chart itself: click the chart title, or either axis title, and type. The Y-axis title is taken automatically from the calculation's quantity and unit until you type your own.
Everything else is in the settings panel beneath the chart, split into three tabs (the arrow at the right folds the panel away to give the chart more room):
- Series — one line per series: its colour swatch, its name (click to rename it), the line / bar / scatter switch, a Style button for that series' colour, thickness, dashes, curve, markers or bar settings, and a ✕ to remove it. Apply defaults to this chart restyles the chart from your saved plot defaults.
- Axes — Bands: a range slider to narrow the frequency window, with Fit to data and Full range buttons, and a Frequencies checklist to hide individual bands (a hidden band is shown struck-through and can be re-enabled — it is hidden, not deleted). Y range: a minimum, maximum and gridline step (in dB); leave them blank for automatic. Narrowing the range genuinely clips the plotted data. When the range is automatic, the top gridline is padded above the highest value so the peak isn't jammed against the frame. Text: the chart's font and size (8–24); axis spacing scales with the font so labels never collide.
- Page — the paper size, orientation and file format used by Export (see below).
The legend is automatic (from the series names) and sits at the top so it never overlaps the frequency axis. Each entry is drawn the way its series is — the same colour, dashes, markers or bar — so it always matches the chart.
Zooming and panning
The buttons at the top left of the Plot pane zoom the chart in and out and reset it. You can also scroll over the chart to zoom, drag to pan once zoomed in, or press +, −, 0 (reset) and the arrow keys while the chart has focus. Zooming only magnifies your view of the chart, like zooming into a PDF: it never changes the data, the axes or the Y range.
Live updates, and following a calculation
- Plots are live: the chart re-reads its source cells whenever the spreadsheet changes, so editing an input updates the chart immediately.
- When you move a calculation by dragging its coloured gutter handle — even to a different sheet — any plotted series follow it automatically and keep tracking its output.
- A single plot can hold series drawn from different sheets at once.
Exporting
The two buttons at the top right of the Plot pane are Export and Copy to clipboard.
Export saves the chart as PNG, JPEG, or PDF, using the page size (A3, A4 or A5), orientation (portrait or landscape) and format chosen in the settings' Page tab. The chart is re-rendered off-screen at the true paper dimensions (about 150 dpi), so the export looks laid out for print rather than a stretched screenshot — only the page rotates, never the plot. The default filename comes from the chart title.
Copy to clipboard copies the chart at its on-screen size as a PNG, ready to paste straight into a report or email.
Both capture what you are looking at: if you have zoomed in, they produce the magnified region (re-drawn at full resolution, not a blurry screenshot). Reset the zoom first to export or copy the whole chart.
💡 The ribbon's zoom buttons zoom the spreadsheet grid, not the chart. To zoom a plot, use the zoom buttons in the Plot pane itself.