AH Datalytics
Chart Builder
Chart Type
Table
Bar
Line
Multi-Line
Multi Bar
Scatter
Small Mult.
Facet H-Bar
Pie/Donut
Stacked Area
US Map
Heat Table
Title
Subtitle
Source
Title size
Subtitle size
Source size
Table Data
Paste directly from Excel / Google Sheets
Left-align columns
Number format
Auto
Commas
1 decimal
None
Force text columns
Force number columns
Override auto-detection: text cols won't be formatted; number cols always format.
Right-align numbers
Row banding
Table density
Compact
Normal
Spacious
% Change
Add % Change column
From column
To column
Color % columns (green/red)
Auto-detects columns with % values.
Invert colors (up=green, down=red)
Sort
Sort by column
— None —
Direction
▲ Ascending
▼ Descending
Totals
Add total row
Sums all numeric columns.
Total row label
Highlight
Bold rows (by text match)
Comma-separated. Bolds any row containing the text.
Highlight color
Conditional Colors
Color column
-- None --
Above threshold
Color
Below threshold
Color
Heat Map Data
Paste directly from Excel / Google Sheets
Heat Map Columns
Paste data to select columns
Check columns to apply color gradient. Uncheck to leave plain.
Gradient
Type
Single
Diverging
Low color
White
High color
Low color
High color
Midpoint
Scale
Color scale
Per Column
Per Row
Shared
Table Options
Left-align columns
Number format
Auto
Commas
1 decimal
None
Right-align numbers
Row banding
Table density
Compact
Normal
Spacious
Sort
Sort by column
— None —
Direction
▲ Ascending
▼ Descending
% Change
Add % Change column
From column
To column
Color % values (green/red)
Invert colors (up=red, down=green)
Totals
Add total row
Sums all numeric columns.
Total row label
Small Multiples Data
Each series becomes its own mini chart
Chart type
Line
Bar
Charts per row
Chart width (px)
Chart height (px)
Line width
Shared Y axis scale
All charts use the same Y range for easy comparison
Y axis starts at 0
Fill under line
Color
Show data labels
Bar Chart Data
Col 1 = X labels, Col 2 = values
Bar Color
Highlight Color
Highlight labels (comma-sep)
Show data labels
Red for negative values
Corner radius
Direction
Vertical
Horizontal
Line Chart Data
Col 1 = X labels, Col 2 = values
Line Color
Fill under line
No
Yes
Point radius
Line width
Show data labels
Multi-Line Data
Col 1 = X labels, rest = series
Point radius
Line width
Show data labels
Dual Y Axis
Enable right Y axis
Right axis series (comma-sep #)
Left Y label
Right Y label
Series Colors
+ Add Series Color
Scatter Data
Col 1=X, Col 2=Y, Col 3=label (optional)
Point Color
Point radius
Highlight
Highlight point
- None -
Uses labels from column 3 of the scatter data.
Highlight color
Show selected point label
Show all point labels
Multi-Bar Data
Col 1 = X labels, rest = series (grouped bars)
Bar width ratio
0.1 (thin) to 1.0 (no gap between groups)
Stacked bars
Series Colors
+ Add Series Color
Show data labels
Corner radius
Facet Horizontal Bar Data
Col 1 = row labels, rest = one facet per column
Bar height (px)
Row gap (px)
Facet gap (px)
Max bar width (px)
Facet Colors
+ Add Facet Color
Shared scale across facets
All facets use same max for bar widths
Show values on bars
Pie / Donut Data
Col 1 = labels, Col 2 = values
Donut (hole in center)
Donut hole size
% of radius (only for donut)
Show labels
Show percentages
Stacked Area Data
Col 1 = X labels, rest = series (stacked)
Line width
Opacity (%)
Show data labels
Series Colors
+ Add Series Color
US State Map Data
Col 1 = state abbreviation (TX, CA, etc.) or full name, Col 2 = value
Low color
High color
No data color
Show state abbreviations
Show values on states
Legend title
Axes
X Label
Y Label
Value prefix
Value suffix
Applied to Y axis ticks, data labels, and tooltips.
Y Min
Y Max
Y step
Show every Nth X
X label rotation
Auto
Horizontal (0°)
Diagonal (45°)
Vertical (90°)
Wrapped
X label font size
Y label font size
X Min (scatter)
X Max (scatter)
X step (scatter)
X tick every N (scatter)
X label prefix
X label suffix
Zero Lines
Bold X=0
Bold Y=0
X Date Options
Time-proportional X axis
Spaces dates by actual time gaps (use for unevenly spaced dates)
Date format
No change
YYYY (full year)
'YY (short year)
MM/DD
Mon YYYY (e.g. Jan 2024)
Mon 'YY (e.g. Jan '24)
Reformats X labels that look like dates (MM/DD/YYYY, YYYY-MM-DD, etc.)
X Start (date filter)
X End (date filter)
Width (px)
Height (px)
Presets
Twitter 16:9
Instagram 1:1
Slide 16:9
Report 4:3
Wide Banner
Show legend
Legend position
Top
Bottom
Right
Reference Line
Y value
Label
Color
Trend Line
Show trend line
Type
Linear
3-period MA
5-period MA
Annotations
Add reference lines, shaded ranges, or text labels to your chart.
+ Add Annotation
Presets
Save Preset
No saved presets
Output
Transparent background
Show AHD logo
Export resolution
2x (standard)
3x (high)
4x (print)
Configure your chart and click
Render
💾 Export PNG
📋 Copy Image
⧉ Copy HTML
🎬 Export GIF