How to Make Charts in PowerPoint: Complete Guide for Consultants

Most chart selection guides offer the same generic advice: use bar charts for comparisons, line charts for trends, pie charts for composition. The advice is correct but incomplete. It does not explain why a horizontal bar chart outperforms a vertical column chart when you have 12 categories with long labels, or why a stacked bar with 8 segments becomes unreadable while one with 4 segments works perfectly.

This guide covers the decision factors that textbooks skip: when native PowerPoint falls short, which formatting choices trigger revision requests, and the chart types you cannot create without workarounds or add-ins. For a comprehensive overview of every chart type consultants need, see our PowerPoint Charts Guide.

Chart Types: The Complete Overview#

PowerPoint offers close to 20 chart types, but consultants use a handful repeatedly.

Standard Charts (Native PowerPoint)#

Consulting Charts (Require Add-ins or Workarounds)#

For waterfall, Gantt, and Mekko charts, add-ins like Deckary are the practical solution. Native PowerPoint simply cannot create true Mekko charts or properly formatted Gantt charts.

Chart Type Decision Matrix#

When you are staring at data and unsure which chart to use, ask yourself one question: What story am I trying to tell?

Key decision for bar vs. column: Use horizontal bars when category labels are long. Use vertical columns for time-based categories or fewer than 6 items.

Critical pie chart rule: Pie charts work best with fewer than five categories. If you have ten slices, your audience will spend more time decoding the chart than understanding the insight. Use a bar chart instead.

For stacked bar charts, see our stacked bar chart guide.

Step-by-Step: Creating and Formatting Charts#

The process for creating any chart in PowerPoint is the same: click Insert > Chart, select the type and subtype, click OK, then replace the sample data in the spreadsheet that opens. The real work is in the formatting.

Formatting for Professional Results#

The default PowerPoint chart looks amateurish. Fix it with these adjustments:

1. Remove unnecessary elements — Delete gridlines, the default chart border, and the default legend
2. Adjust bar width — Right-click any bar > Format Data Series > set Gap Width to 100-150%
3. Add data labels — Click the chart > click the + icon > check "Data Labels"
4. Set appropriate colors — Use 2-3 colors maximum. Highlight the key data point with an accent color; keep supporting bars in gray
5. Fix the axis — Ensure Y-axis starts at zero for bar charts. Remove the axis entirely if data labels make it redundant

Pro tip: The default chart title and legend are notoriously difficult to format. Delete them and add your own text boxes for full control over fonts, sizes, and positioning.

Common Formatting Mistakes#

The "Slide Sorter Test"#

Before finalizing any chart, switch to Slide Sorter view and look at your slide from a distance. If you cannot read the chart clearly at thumbnail size, your labels are too small and your chart is too complex.

Advanced Charts: Waterfall, Gantt, and Mekko#

These charts are consulting staples but present challenges in native PowerPoint.

Waterfall Charts#

Native PowerPoint added waterfall charts in 2016, but the implementation has limitations: no stacked waterfalls, no live Excel linking, difficult connector formatting, and inconsistent negative value handling. For professional waterfall charts, add-ins like Deckary create them in seconds with automatic formatting. See our waterfall chart guide for detailed instructions.

Gantt Charts#

Native PowerPoint has no Gantt chart type. Your options are a stacked bar workaround (30-45 minutes, breaks when dates change), SmartArt timeline (sequential milestones only), or add-ins like Deckary and Office Timeline that create proper Gantt charts with automatic date handling.

For step-by-step instructions, see our Gantt chart guide.

Mekko (Marimekko) Charts#

PowerPoint cannot create Mekko charts natively. The charting engine does not support variable-width columns. Mekko charts show two dimensions simultaneously: column width represents market or segment size, while column height represents percentage composition or market share.

Deckary offers Mekko charts at $49-119/year with Excel linking and automatic formatting. See our Mekko chart guide for detailed use cases.

Tornado Charts#

Tornado charts visualize sensitivity analysis — which variables drive the most impact on an outcome. Native PowerPoint requires a stacked bar workaround with manual formatting. For consulting-quality tornado charts, see our tornado chart guide.

Linking Charts to Excel#

If your data changes frequently, linking charts to Excel prevents manual updates.

1. In Excel: Create and format your chart
2. Copy the chart (Ctrl+C)
3. In PowerPoint: Click Home > Paste dropdown > Paste Special
4. Select "Paste Link" and choose your format

The chart now updates when Excel data changes. Right-click the chart > Update Link to refresh manually, or changes propagate automatically when you open the file.

Limitations: Charts created directly in PowerPoint (Insert > Chart) cannot be linked to external Excel files. Linked charts may break if the Excel file moves or is renamed. For reliable Excel linking with professional formatting, add-ins like Deckary maintain links even when files are shared across teams.

Tools Comparison: Native vs. Add-ins#

For consultants building charts regularly, the productivity gains from add-ins pay for themselves quickly. A waterfall chart that takes 30 minutes in native PowerPoint takes 30 seconds with the right tools.

Summary#

Creating professional charts in PowerPoint requires three things: choosing the right chart type, formatting for clarity, and using appropriate tools for advanced visualizations.

1. Match chart type to message — Bar for comparison, line for trends, pie for simple composition, waterfall for variance
2. Format for readability — 20pt minimum fonts, remove gridlines, avoid 3D effects, use consistent colors
3. Start bar charts at zero — Truncated axes distort perception
4. Consider add-ins for advanced charts — Native PowerPoint cannot create Mekko, Gantt, or stacked waterfall charts
5. Link to Excel for dynamic data — Use Paste Special > Paste Link or add-ins for live updates

The goal of any chart is to make data obvious at a glance. If your audience needs more than five seconds to understand the point, simplify the chart or choose a different type.

---