Chart Title
Data Visualization Toolkit
Chart Builder
Vanguard Quality Partners
Defects Out. Confidence In.
vanguardqualitypartners.com
Defects Out. Confidence In.
vanguardqualitypartners.com
1 Your data
Sample data
Tip: drag an Excel or CSV file onto the page to import a sheet, or open the Data table tab to add rows, columns and type values.
2 Chart type
Scatter plots an X–Y relationship: put numeric X values in the first column and Y values in each series column.
Box plot: enter the raw measurements for each box down its own column (one column = one box). Each box shows the median, the middle 50% (Q1–Q3), whiskers, and any outliers.
Multi-level donut: each column becomes a concentric ring (inner → outer), and each row is a colored segment. Add columns to stack more rings.
Open the Data table tab to enter your data, then pick a chart type…
3 Titles & options
Your data set
Add rows and columns, type values, or paste a block from Excel.
Tip: select a block of cells in Excel/Sheets and paste straight into the grid — it expands to fit. Each row is a category, each column a series. Click a colour swatch to recolour a series.
Vanguard Quality Partners · Measure. Improve. Excel.
© Vanguard Quality Partners. Template for client use. vanguardqualitypartners.com