Charts Studio
Charts Studio at /charts turns tidy tables into scatter, line, bar, histogram, box, and heatmap figures without shipping your dataset to a charting SaaS. Upload CSV, TSV, Excel, or JSON, map columns to axes and color encodings, tune labels, and preview updates instantly while the source rows remain in memory on your device. The studio fits slide decks, blog graphics, homework figures, and ad-hoc stakeholder updates where you already use UtilBloom for PDFs or Data Lab for profiling. When exploration matters more than pixel-perfect export, start in Data Lab; when the table is clean and you need the right chart grammar fast, build here. Exports aim to be share-ready PNG or SVG-style outputs depending on what the workspace exposes in your build.
What you can do
- Multi-format ingest
Accept common tabular interchange formats so you can paste JSON from an API log, drop a TSV from a shell pipeline, or open an Excel export without converting twice.
- Chart grammar picker
Switch among scatter, line, bar, histogram, box, and heatmap views with column roles for x, y, series, and color when the data supports that visualization honestly.
- Axis and label controls
Set titles, tick formatting, and legend placement so figures read clearly in print and projector contexts without opening a desktop publishing stack.
- Live preview
See the figure update as you remap columns or filters, which reduces the edit-export-open loop that slows down iterative storytelling.
- Distribution views
Histograms and box plots highlight skew and outliers, useful when a mean summary from Scientific Lab or Data Lab hides a bifurcated sample.
- Heatmaps for matrices
Visualize correlation-style grids or category grids when two dimensions and a numeric intensity field are present in the uploaded table.
Worked examples
Weekly active users line chart
week, wau.csv with columns week_start and active_users
Map week_start to the x-axis and active_users to y, choose line mode, and enable point markers if some weeks are sparse so stakeholders see missing samples.
Exam score histogram
scores.json array of student_id, score
Select histogram on score with sensible bin width to reveal whether the distribution is bimodal before you quote a single class average in a report.
Category sales bars
sales_by_category.tsv
Use bar mode with category on x and revenue on y, sort descending if the UI allows, and color by region only when region is a separate column to avoid misleading stacked bars.
How it compares
Dedicated BI products (Tableau, Power BI, Google Looker Studio) connect to live databases and shared workspaces UtilBloom does not host. Charts Studio intentionally occupies the single-file, single-session niche: you already have a CSV on disk and need a figure now. Compared to coding matplotlib or ggplot in Jupyter, the studio trades script reproducibility for speed and zero environment setup inside the same tab as UtilBloom’s other labs. For upstream cleaning, pair /datalab; for programmatic batch figures across dozens of files, /codelab may fit better after you outgrow click-based mapping.
Questions
Does Charts Studio send my table to a render farm?
Rendering is designed to stay client-side like other UtilBloom labs. Treat sensitive rows accordingly, but the default architecture avoids a mandatory cloud upload step.
Which chart type should I pick for time series?
Line charts with time on the x-axis are the usual choice. Use scatter if timestamps are irregular; use bars only when intervals are truly categorical buckets.
Can I combine multiple files in one figure?
Merge tables externally or in Data Lab first. Charts Studio expects one primary dataset per session unless the UI exposes an explicit join helper.
Why does my heatmap look empty?
Heatmaps need two categorical or ordered dimensions plus a numeric cell value. Wide one-row tables may need reshaping before intensity shows color.
How do box plots handle outliers?
Box plots summarize quartiles and whiskers based on the column you assign. Extreme values may appear as points depending on renderer rules, verify against raw rows in Data Lab.
Is Charts Studio the same as Graph Lab?
No. Graph Lab plots mathematical relations and tables tied to expressions. Charts Studio maps spreadsheet columns to statistical chart types without a symbolic math list.