Sales Activity (Chart)
Overview
- Column chart rendering monthly revenue across twelve months, one of the thirteen chart forms the Chart web part can draw
- A total revenue callout of $2,999,350 above the plot, generated from the same prompt rather than added as a second web part
- A value label above every column, from $184K to $319K, placed by the web part rather than configured
- A single accent green on a clean rounded card, produced by asking for it – styling in this web part 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
- Answers the question most people open a sales report to ask – how are we tracking this year – in a single glance
- Puts the annual total and the monthly detail in the same frame, so the summary and the evidence can never disagree
- Makes the seasonal pattern visible – the April dip, the softer July, the December peak – without anyone running an analysis
- 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 number lives where the sales team already works
- Restyles on request – a different palette, a different label format – by asking for it in the same chat
Details
- Chart Types: Column chart
Common Questions About the Sales Activity Chart
What is this sales activity 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 chart is described in plain language and drawn on the page itself, with no report server, no gateway, and nothing to license beyond Microsoft 365 and a Copilot seat for whoever builds it. Readers need no license at all – the kind of low-maintenance reporting Greg Zelfond builds for sales teams.
What does the sales activity chart show?
This year’s total revenue as a headline figure of $2,999,350, with twelve columns beneath it covering January through December. Every column carries its own value label, from $184K in January to $319K in December, and the axis runs from zero to 400K so the proportions stay honest. Read together, the chart gives both the annual total and the month-to-month climb that produced it.
Where does the chart data come from?
A two-column dataset of month and revenue, 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 a twelve-row revenue set that is a monthly job, not a daily one. 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 sellers already visit. Reach out through the contact page.
