The Chart widget aggregates collection items into bar, line, pie, doughnut, or scatter charts. Visitors can search and filter the underlying rows; the chart reshapes from the filtered set. Connect Wix CMS or an external database the same way as Calendar and other list displays.
The app binds data to this widget — not to native Harmony chart elements.
Use case examples
- Sales by category — Bar or doughnut grouped by a Text / Option field with Sum on Amount.
- Revenue over time — Line (optionally filled as an area) with a date field bucketed by day, week, month, or year.
- Correlation — Scatter with numeric X and Y fields (for example price vs. inventory).
Configure a Chart
Build with AI: Open AI setup at the top of the panel and describe the chart type and fields — then refine in Manual. Details: AI setup.
- Add Chart from Add → Elements → Installed Apps → CMS for Harmony.
- Select the widget → open Settings.
- In Content, connect a data source.
- Choose Chart type and map fields under Data.
- Optionally configure Layout, Search & filters, Data refresh, Design, Content access, and Mobile.
- Publish the site.
Content
Where: Manual overview → Content drill row
Where: Settings → Content
- Set Data source to Wix CMS or External Database (see External databases).
- Set Items to load (default 100; max 1000) — rows are loaded, then aggregated in the browser.
Chart type
Where: Manual overview → Chart type drill row
Where: Settings → Chart type
Pick Bar, Line, Pie, Doughnut, or Scatter.
- Bar — optional Horizontal bars.
- Line — optional Fill area under the line (area style).
- Pie / Doughnut — doughnut adds a cutout percentage.
- Scatter — uses point mapping (X / Y fields) instead of group-by.
Data
Where: Manual overview → Data drill row
Where: Settings → Data
Group by field (bar, line, pie, doughnut)
- Set Data mode to Group by field (default) or Time series.
- Choose Group by (text, option, reference label, tags, or date for time series).
- For time series, set Time bucket to day, week, month, or year.
- Set Value field to a number (or leave empty to Count items) and Aggregate (count, sum, avg, min, max).
- Optionally Split into series with a categorical field, or add extra numeric Series value fields.
- For pie / doughnut, set Max slices — remaining groups combine into Other.
Points (scatter)
- Chart type Scatter switches the panel to Points (X / Y).
- Map X field and Y field (numeric; X may be a date).
- One point is drawn per loaded row (after filters), up to the items limit.
Search & filters
Where: Manual overview → Search & filters drill row
Where: Settings → Search & filters
Full reference: Search & filters. Filters and search reshape the rows that feed the chart.
Data refresh
Where: Settings → Data refresh
Full reference: Data refresh. Reloads collection rows, then rebuilds the chart.
Design
Where: Settings → Design
Set chart title and subtitle, height, legend, animation, colors (background, text, muted, border, grid), and doughnut cutout when applicable.
Layout
Where: Settings → Layout
Legend position, and for bar, line, and scatter: axis titles, begin at zero, stacked bar/line, dual Y-axis for multi-series, and related scale options.
Content access
Where: Settings → Content access
Same Pro Content access rules as Table, Repeater, and Dynamic Page — members or pricing plans. Full reference: Content access.
Mobile
Where: Settings → Mobile
- Set On small screens (keep desktop or compact).
- Set the Breakpoint (320–1200 px).
FAQ
Which chart types are available?
Bar, line, pie, doughnut, and scatter, with group-by, aggregates, and optional series.
Can Chart use Google Sheets?
Yes — Chart supports Wix CMS and external databases.
Does Chart support search, filters, and Content access?
Yes — Search & filters, data refresh, Content access (Pro), and AI setup.