Charts & Visualizations
Transform your pivot table data into beautiful, insightful charts.
Adding a Chart
- Create or open a report with a pivot table that has data
- Click the "+ Add Chart" button above the pivot table
- Select a chart type from the gallery
- The chart appears and automatically visualizes your pivot data
- Customize using the chart settings panel
Tip: Charts are linked to your pivot table. When you modify the pivot layout, the chart updates automatically to reflect the new data.
Chart Types
DATIRA supports 20+ chart types organized into these categories:
Bar Charts
- • Vertical Bar
- • Horizontal Bar
- • Stacked Bar
- • Grouped Bar
- • 100% Stacked
Best for: Comparing categories, ranking items
Line Charts
- • Basic Line
- • Multi-Line
- • Stepped Line
- • Spline (Smooth)
Best for: Trends over time, continuous data
Area Charts
- • Basic Area
- • Stacked Area
- • 100% Stacked Area
- • Spline Area
Best for: Volume over time, part-to-whole trends
Pie & Donut
- • Pie Chart
- • Donut Chart
- • Semi-Circle
- • Nested Donut
Best for: Part-to-whole (5-7 categories max)
Scatter & Bubble
- • Scatter Plot
- • Bubble Chart
- • Scatter with Trendline
Best for: Correlation, distribution, outliers
Gauges & KPIs
- • Radial Gauge
- • Linear Gauge
- • KPI Card
- • Progress Ring
Best for: Single metrics, targets, progress
Additional Chart Types
Combo Charts
Combine bar and line on the same chart. Great for showing volume (bars) and trend (line) together.
Waterfall
Show how values contribute to a total. Visualize increases and decreases over categories.
Treemap
Hierarchical data in nested rectangles. Size represents value, color represents category.
Heatmap
Grid of colored cells where color intensity represents value. Great for correlation matrices.
Funnel
Show conversion or drop-off across stages. Perfect for sales pipelines and user journeys.
Radar / Spider
Compare multiple variables. Useful for performance profiles and multi-criteria analysis.
Chart Customization
Click on a chart to open the settings panel. Available customizations:
Colors & Styling
- Color palette — Choose from preset palettes or create custom
- Individual series colors — Click on legend items to change specific colors
- Background — Transparent, solid, or gradient backgrounds
- Border & shadow — Add depth with borders and drop shadows
Labels & Text
- Chart title — Add a main title and subtitle
- Data labels — Show values on bars, points, or slices
- Axis labels — Customize X and Y axis titles
- Legend — Position, show/hide, customize text
Axes & Gridlines
- Scale — Linear, logarithmic, or custom range
- Min/Max values — Set fixed axis boundaries
- Gridlines — Show, hide, or style horizontal/vertical gridlines
- Tick marks — Customize interval and formatting
- Dual axis — Add a secondary Y-axis for different scales
Interactivity
- Tooltips — Customize what shows on hover
- Click actions — Drill-down to detail data
- Zoom — Enable pan and zoom for large datasets
- Animation — Enable/disable chart animations
Chart Best Practices
Do ✓
- ✓ Choose the right chart for your data type
- ✓ Keep it simple — remove unnecessary elements
- ✓ Use meaningful titles and labels
- ✓ Start bar chart axes at zero
- ✓ Limit pie charts to 5-7 slices
- ✓ Use color consistently across dashboards
Don't ✗
- ✗ Use 3D effects (they distort perception)
- ✗ Overcrowd with too many data series
- ✗ Use pie charts for many categories
- ✗ Truncate axes to exaggerate differences
- ✗ Use hard-to-read color combinations
- ✗ Skip axis labels or units
Choosing the Right Chart
| Question You're Answering | Recommended Chart |
|---|---|
| How do values compare across categories? | Bar Chart (vertical or horizontal) |
| How has a value changed over time? | Line Chart |
| What's the part-to-whole breakdown? | Pie, Donut, or Stacked Bar |
| Is there a relationship between two variables? | Scatter Plot |
| How does volume change over time? | Area Chart |
| What's the distribution of values? | Histogram or Box Plot |
| How are values contributing to a total? | Waterfall Chart |
| What's the conversion through stages? | Funnel Chart |
| What's my current status vs target? | Gauge or KPI Card |
Multiple Charts per Report
You can add multiple charts to a single report to show different views of the same data.
Free Plan
1 chart per report
Pro & Business
Unlimited charts per report
Layout tip: Use the chart resize handles to arrange multiple charts. They automatically snap to a grid for clean alignment.
Exporting Charts
Export your charts for use in presentations, reports, or other applications.
- PNG — High-quality image with transparent background option
- SVG — Vector format, scales perfectly at any size
- PDF — Print-ready format
- Copy to clipboard — Paste directly into other applications
To export: Right-click on a chart → Export → Choose format