Sheet
File
Analysis
Graph
Size & export
View

Tips

  1. 1PasteCopy a table from Excel and paste it into the bar under the sheet.
  2. 2Pick a testChoose it in Analysis; results and the figure update as you type.
  3. 3Edit the figureClick any text or bar on the figure; right-click for more.

Your data

Layout
One column per group. Paired, repeated-measures and Friedman tests match values by row (one subject per row). Correlation uses column A as X and B as Y. Contingency tables hold counts: columns are groups, rows are outcomes (named by the row titles).
Two-way
Columns are the levels of one factor (e.g. Control / Drug); the row title names the level of the other (e.g. Male / Female). Put each replicate on its own row and repeat the row title.
Clusters
For bars in clusters with letters over each bar (e.g. Control, P1–P3 × M1–M3), choose One-way ANOVA across grouped cells. The row title names the cluster on the x axis and each column is a bar colour; every row-title × column cell is one group, and cells may stay empty (a Control row fills only its own column).
Curves
Dose–response curve (4PL): column A = dose, the other columns = replicate responses; a four-parameter logistic is fitted on log10(dose) and reports EC50 / IC50 with its 95% CI. Kaplan–Meier survival: column A = time, each other column a group with 1 = event and 0 = censored (blank = not in that group); curves are compared with the log-rank test.
Exclude
Right-click a column (or a block of columns) and choose Exclude from the analysis to keep the data on the sheet but out of the test and the figure. The same menu includes it again.
Outliers
Grubbs' test (α = 0.05) runs on every column; suspected outliers are highlighted on the sheet and listed in the results, but nothing is removed. Right-click a cell → Exclude value to leave it out (it stays on the sheet, struck through); the same menu includes it again.

The sheet

Sheets
The tabs over the sheet each hold their own data, test, figure options and undo history: one tab per figure. + (or a double-click on the empty strip) adds one; double-click a tab to rename it; right-click to duplicate, move or delete. Save writes every tab into one .jgz file, and Open adds a file's tabs to the ones you have.
Paste
Paste a block from Excel/Sheets into any cell (⌘/Ctrl V); the grid expands to fit. To replace the whole sheet, click the paste bar under the sheet (or Paste in the ribbon) and press ⌘/Ctrl V: tables from Excel, Word, web pages, PDFs and CSV text all work, with or without a header row. You can also drop a .csv / .txt file on the bar.
Select
Click a cell and just type to replace it; double-click or F2 to edit inside it. Drag, or Shift + click / arrows, to select a block; click a row number or column letter for a whole row or column; ⌘/Ctrl A selects everything. Click the empty grid to add rows and columns there.
Move
Arrows, Tab and Enter move between cells (Enter on the last row adds one); ⌘/Ctrl + arrow jumps to the edge.
Edit
Copy, cut and paste work on blocks; one copied value pasted onto a block fills it. Delete clears the block, ⌘/Ctrl D fills down, Esc cancels a change. Type a value with a block selected and press ⌘/Ctrl Enter to put it in every cell. Right-click for insert / delete rows and columns. Drag a column by the dotted handle at the left of its name (or right-click → Move left / right) to reorder it; the figure follows. Results update as you type.
Undo
⌘/Ctrl Z; add Shift for redo. Undo covers the data and the figure settings (chart, colours, size, style, test).

The figure

Figure text
Click any text on the figure to edit it: an axis title, a group name under the x axis, or a legend entry. Group names and legend entries rename the column or row title on the sheet (⌘/Ctrl Z undoes it). Enter keeps the change, Esc cancels. A cleared axis title stays as a faint placeholder on screen so you can click it again; exports leave it out. Off next to *** / P = hides the letters and stars on the figure.
Format
Click a bar to pick its colour, or any text (titles, group names, legend, letters / stars, y-axis numbers) for bold, italic, colour and size. Shift-click bars to select several; right-click the figure to compare the selected bars in a new tab (t-test, Mann–Whitney, ANOVA, Kruskal–Wallis), show or hide them, or copy the figure as SVG or PNG. For finer editing, paste the SVG into svguest.
Style
Style in the ribbon sets the figure's font size, dot size, bar width, hollow or hidden points, and a box or open (left and bottom axes) frame.
Y axis
Style → Y axis: linear or log scale, a fixed range (blank = automatic), a dashed reference line at a value, a shaded band between two values, and a break (from … to …) that cuts the axis with // marks when one group is far taller than the rest.
My style
Style → Save as my default keeps the chart type, error bars, colours, significance labels and style in this browser: Reset, new visits and Examples then use it. Forget it returns to the built-in defaults.
Colours
Besides Claude and Classic Prism, the colour menu offers the journal-style palettes NPG, AAAS, NEJM, Lancet, JAMA, JCO and D3 from ggsci by Nan Xiao (GPL, like plsig).

Results

Results
Click Results to fold the tables away (the one-line conclusion stays), or click one table's title to fold just that table. Folds are remembered.
Methods
Under the results, a ready-to-copy paragraph for a paper's methods section describes the test that ran, its post-hoc test, how the data are shown and the sample size.

Files and sharing

Session
Saved in this browser automatically; Save / Open (.jgz) moves a session between machines.
Files
Open reads a .jgz session, an Excel .xlsx file (each worksheet becomes a tab; formulas give their last computed value) or a .csv / .txt table; you can also drop any of these on the paste bar.
Share
Share (right of the sheet tabs) copies a link that holds every tab, data and settings included. Whoever opens it gets the same sheets and figures; nothing is uploaded, the data travel inside the link. Very large sessions are better sent as a Save file.
Export
Export opens the options: this figure or every sheet as one panel figure lettered A, B, C…, PNG or SVG, the on-screen size or a journal column width (8.5 / 11.4 / 17.4 cm), and 300 or 600 dpi (written into the PNG, so Word and Illustrator open it at that size). Copy puts the figure on the clipboard for PowerPoint, Word or a chat.
Offline
After one visit online, the page works without a network (it keeps itself and its two scripts in the browser).

About

Theme
The sun / moon button in the ribbon's View group switches between light and dark; 中 / EN switches the interface between Chinese and English (the figure itself stays in English, for papers).
Privacy
Everything runs in this browser; your data is never uploaded.
Source
Open source on GitHub: report a problem or suggest a feature under Issues.