In this lesson
Build an editable ticket-volume chart and make its title, labels and emphasis easy to read in a meeting room.
Practice material
Compare the worked answer
Start with the practice file. Open the worked answer after trying the exercise. CSV and text briefs are also available. All resources and import notes →
Example
Ticket volume slide
Slide 3 needs to show monthly ticket volume: July 1,240, August 1,610, September 1,180. A pasted screenshot from a dashboard is blurry and can't be edited.
Ticket volume peaked in August
How it works
An embedded native chart includes editable worksheet data inside the presentation. A linked Excel chart depends on an external source and permissions; a screenshot contains pixels and cannot update through Edit Data.
Highlight the peak while keeping the data unchanged. Start this column chart at zero and include all four months after adding October. Keep the value labels visible so the conclusion also makes sense without colour.
Use a table when readers need exact values and a chart when they need to see the pattern. For an Excel handoff on desktop, create the same five-row worksheet and use the available paste options for an editable table or embedded copy. A linked object also needs access to its source file. A screenshot cannot update through Edit Data.
Steps
Open powerpoint-chart-starter.pptx, or build the six-slide outline in Section A of presentation-brief.md. On slide 3, choose Insert › Chart › Column › Clustered Column.
In the data sheet that opens, enter Month / Tickets with Jul 1240, Aug 1610, Sep 1180. Drag the blue range border so only these rows are included, then close the sheet.
Select the chart, open Chart Elements (the + button), clear Gridlines and Legend, and check Data Labels.
Click the August bar twice to select only that bar and give it your accent color with Format › Shape Fill. Set the other bars to a neutral gray.
Keep the slide title as the takeaway: “Ticket volume peaked in August”.
As a rule of thumb, keep body text at 18 pt or larger and chart labels at 14 pt or larger. Change fonts once in View › Slide Master, not slide by slide.
On the fifth slide, add an evidence table with Insert › Table: two columns and five rows. Enter Month / Tickets followed by Jul 1240, Aug 1610, Sep 1180 and Oct 1050. Apply a header row and keep the table unmerged so readers can check the exact values alongside the chart.
Try it yourself
- Right-click the chart › Edit Data and add Oct 1050.
- Update the title so it describes the trend after the peak.
Show expected result
- The chart shows four bars with data labels, no legend and no gridlines.
- Only the August bar uses the accent color.
- The title reads something like “Ticket volume fell steadily after the August peak”.
If something goes wrong
- October is in the worksheet but no fourth bar appears.
- Extend the chart source-data range to include the Oct row. Reopen Edit Data and confirm that the category labels and series values use the same four rows.
- All bars change colour when only August should change.
- The first click selects the whole series. Click August again to select that single data point, then set its fill. Confirm Jul, Sep and Oct remain neutral.
Quick check
Try these questions after the exercise. Check the result in your app before marking the lesson complete.
Choose an answer for all 3 questions to check your understanding.
Optional: try it with Copilot
If you have Copilot, try this after the exercise. Keep the original file and compare its suggestions with your own result.
Suggest a one-sentence slide title for a chart showing support tickets: Jul 1,240, Aug 1,610, Sep 1,180, Oct 1,050. Then suggest two short speaker-note points that explain the trend without adding numbers that aren't in the data.
More from Microsoft
These Microsoft guides cover the tools used in this lesson.
Loading your progress…