PlotStudio

Worksheet

• Arrow keys / Enter — move between cells
• Shift+click — select a cell range
• Ctrl/Cmd+C — copy selected range
• Drag the small square at the corner of a selection — fill down (repeats values, or continues an arithmetic sequence if 2+ numeric cells are selected)
• Click the ⇅ arrow in a column header — sort ascending/descending
• Double-click a column header — rename it / change its role (X, Y, or text)
• Paste tab-separated data (e.g. from Excel) directly into the grid
• Worksheet menu — Insert/Delete Column or Row at any position (not just the end), Duplicate Column, Find & Replace

Undo / Redo / Save

• Ctrl/Cmd+Z — undo (covers worksheet edits, formulas, imports, annotations, and graph changes)
• Ctrl/Cmd+Y or Ctrl/Cmd+Shift+Z — redo
• Ctrl/Cmd+S — save the project (.json) without opening the File menu

Graphs

• Use the ＋ next to "Graphs" in the left panel to add another graph; click a graph's name to switch to it
• "2nd axis" chip next to a Y column — plot that series on a secondary Y axis
• Scroll to zoom, drag to pan — Line/Bar/Scatter/Bubble charts; "Reset Zoom" button clears it
• Drag to rotate / scroll or pinch to zoom — 3D Scatter and Surface plots

Python & Script Consoles (Automation menu)

• Script Console — plain JS. Edit data.ColumnName and run to write changes back to the worksheet; console.log(...) or return value; to see output.
• Python Console — loads Pyodide on demand (needs internet the first time per session). data holds your columns; load pandas for a df DataFrame; set new_columns = {...} to add worksheet columns.

Both consoles run entirely in your browser — nothing is uploaded anywhere, and the Script Console needs no internet connection at all.

PlotStudio implements the parts of a full desktop-style scientific graphing suite that can genuinely run inside one HTML file in a browser: CSV/Excel import, multiple worksheets and multiple graphs per project (each with its own type, columns, and style — switch between them like tabs), an editable worksheet with column formulas, keyboard navigation, copy, drag-fill (touch-friendly), sort, find & replace, insert-column-at-position, and full undo/redo covering both worksheet and chart edits. A wide range of 2D chart types (including real per-point ± error bars, a secondary Y axis, and color-by-category grouping), a dependency-free interactive 3D scatter/surface view and a flat contour plot (drag or touch to rotate, scroll or pinch to zoom — no external 3D library needed), curve fitting including weighted least squares, outlier exclusion, Linear/Poly/Exponential/Power/Logistic/Gaussian presets plus a custom equation fit (type any y=f(x) or z=f(x,y) expression and it's fit with a built-in Nelder–Mead simplex solver), a residuals plot and an approximate 95% confidence band, small-multiples batch plotting, smoothing/FFT/peak-finding, real one-way and two-way ANOVA, a Welch's t-test, and a Pearson correlation matrix — all with actual p-values from a proper F/t-distribution engine. Chart annotations (reference lines, text labels), reusable graph-style templates, session autosave, dark mode, and full project Save/Load (.json) plus real vector SVG export (for line/bar/scatter/area/step) and PNG/CSV export round it out. There's also a sandboxed JS Script Console and a full Python Console (Pyodide/WASM, loaded on demand, with on-demand pandas support) with your worksheet columns available as data (and df once pandas is loaded).

Honestly out of scope for a single client-side HTML file (marked stub in the menus, shown as informational dialogs rather than fake working buttons):

• ODBC/ADO database connectivity, and direct OneDrive/Google Drive OAuth — needs a real backend/server and credentials.
• Reading proprietary binary formats: NI TDM(S), MATLAB .mat, LabVIEW .lvm/.tdms — needs native parsing libraries.
• Legacy vendor-specific macro languages and native compiler toolchains — proprietary technologies tied to specific desktop software runtimes.
• Generating actual Word/PowerPoint files with linked live graphs — possible with server-side libraries, not in-browser only.
• Survival analysis and a full image-processing suite — large enough to be separate apps; noted as roadmap items.
• SVG export covers Line/Bar/Area/Step/Scatter; Pie/Radar/Box/3D/Contour still need PNG (a true vector path for those is a reasonable follow-up, not included here).
• The confidence band uses a normal (Z=1.96) approximation rather than an exact Student-t critical value — reasonable for most sample sizes, but not exact for small n.

Everything else in the menus is fully functional against whatever data you import or type into the worksheet.