Budget by Department (Chart)
Overview
- Donut chart rendering budget by department, one of the thirteen chart forms the Chart web part can draw
- A ranked legend beneath the ring listing every department with its exact figure, generated from the same prompt rather than built by hand
- A hover tooltip naming the segment and its value, standard interactive behavior in this web part rather than a setting to switch on
- A single-hue purple ramp running darkest to lightest by size, produced by asking for it – styling here is a conversation, not a property pane
- The whole visual described in plain language in a chat on the page, with follow-up prompts to add data, change the look, or undo a step
- Roughly thirteen chart forms available – bar, line, pie, donut, area, scatter, histogram, heatmap, funnel, sankey, gauge and more – so the shape follows the question rather than the tool
- Authoring needs a Microsoft 365 Copilot license while readers need none, and the chart holds its data as a snapshot that is refreshed by asking
Benefits
- Shows share and exact amount at the same time, which a pie alone or a table alone never manages
- Makes the concentration obvious – Information Technology alone is close to a third of the total – without anyone doing the arithmetic
- Gives every department its own line and its own number, so the conversation starts from agreed figures
- Fits a narrow page column, which is where budget commentary usually lives
- Takes minutes to build, because the chart is described in words rather than configured field by field
- Needs no Power BI workspace, no gateway, and no report developer
- Embeds directly into a SharePoint page, so the allocation sits alongside the policy that explains it
Details
- Chart Types: Donut chart
Common Questions About the Budget by Department Chart
What is this budget chart built with?
The Chart web part, the AI-powered chart web part that sits under the AI category in the SharePoint web part toolbox. The donut, the color ramp, and the ranked legend all come from a plain-language prompt rather than a property pane. There is no reporting tool to buy and nothing to license beyond Microsoft 365 and a Copilot seat for whoever builds it – the kind of low-maintenance reporting Greg Zelfond builds for finance teams.
What does the budget by department chart show?
Seven departments as segments of a single donut, sized by budget and shaded on one purple ramp from darkest to lightest. Beneath the ring, a ranked legend lists each department with its exact figure – Information Technology $1,250,000, Operations $980,000, Sales $845,000, Marketing $610,000, Human Resources $395,000, Finance $340,000, and Legal $215,000.
Where does the chart data come from?
A two-column dataset of department and budget amount, held in a file the web part reads when the chart is created. The Chart web part does not bind to a SharePoint list the way the classic Quick Chart web part does; it takes the numbers it is given and draws them.
Does the chart refresh automatically when the numbers change?
No. The Chart web part holds its data as a snapshot, so editing the source file does not redraw the chart on its own – you ask the web part to refresh the data and republish the page. For an annual allocation that changes once a budget cycle, that is rarely a burden. When a live-refreshing view is the requirement instead, the classic Quick Chart web part can point straight at a SharePoint list, and Power BI handles scheduled refresh.
Should we use the Chart web part, a Copilot dashboard, or Power BI?
It depends on how much you need. The Chart web part is the quickest way to put one good-looking chart on a page, described in a sentence and styled by asking. A Copilot-generated dashboard suits a full page with filters and several linked charts that move together. Power BI earns its place when data volumes are large, sources need joining, or row-level security and scheduled refresh matter.
Can Greg build this chart for our organization?
Yes – this is exactly the kind of work Greg Zelfond does. As an independent SharePoint consultant and Microsoft MVP, he shapes the underlying data so the chart is worth drawing, picks the visual that answers the question your leadership actually asks, and puts it on a page your department heads already visit. Reach out through the contact page.
