Charts and pivot tables

Create bar, line and pie charts and pivot tables in Kazi Sheets, and use them in Kazi Docs and Slides.

#Create a chart

1. Select your data, including the header row (for example A1:B7).
2. Click + Add Chart on the toolbar (or Insert → Reactive Sheet Chart…).
3. Choose Bar, Line or Pie, give it a title, and confirm.

Charts are reactive: change a number in the range and the chart redraws.

#Use a chart in a document or deck

• In Kazi Docs: Insert → Live Kazi Sheets Chart.
• In Kazi Slides: Insert → Live Synchronized Kazi Sheet Chart…

#Pivot tables

Pivot tables summarise long lists, for example total sales per salesperson per month.

1. Make sure your data has a header row and no empty columns.
2. Open Data → Pivot Table & Group-By Studio…
3. Choose the column to group by (rows), and the column to summarise with Sum, Count or Average.
4. Insert the result into a new area or sheet.

#Turn analysis into a report

• Publish to Kazi Doc Report creates a document from the sheet.
• Generate Kazi Slides Deck creates a presentation from your data.
• Send Analyst Briefing to Notes writes a summary note.