How to How to Create Cone Chart in Excel in Excel - Practical Guide

Learn how to create a cone chart in Excel to visualize hierarchical or progressive data with a distinctive 3D cone shape. Cone charts are ideal for displaying sales funnels, organizational structures, or staged processes where data decreases proportionally at each level, making trends immediately visible.

Why This Matters

Cone charts enhance data storytelling by making hierarchical relationships visually intuitive, particularly effective for presenting sales pipelines and funnel analysis to stakeholders. This advanced charting skill strengthens professional presentations and data communication.

Prerequisites

•Basic understanding of Excel spreadsheets and data entry
•Familiarity with the Insert tab and chart creation fundamentals

Step-by-Step Instructions

Prepare Your Data

Organize your data in two columns: one for categories (labels) and one for values (numbers). Ensure data is clean with no empty cells, as Excel uses this format to build cone charts.

Select Your Data Range

Highlight your data range including headers by clicking and dragging from the first cell to the last data point. Verify both columns are selected before proceeding to chart creation.

Access Insert Charts Menu

Navigate to Insert > Charts > Recommended Charts on the ribbon. This opens the chart wizard dialog where you can browse available chart types.

Select Cone Chart Type

In the Recommended Charts or All Charts tab, scroll to find Cone under the 3D column chart category. Click on the cone chart thumbnail to select it, then click OK.

Customize and Finalize

Use Chart Design and Format tabs to add title (Insert > Chart Title), adjust colors (Format > Chart Styles), and modify axis labels. Click outside the chart to deselect and complete creation.

Alternative Methods

Using Chart Wizard (Legacy Method)

Insert > Chart opens the legacy Chart Wizard dialog. Select Column chart type, choose 3D Cone variant from the subtypes, and follow the four-step wizard for more detailed customization options.

Convert Existing Column Chart

Create a standard 3D column chart, then right-click the chart and select Change Chart Type. Choose Cone from the 3D column options to convert instantly without rebuilding.

Tips & Tricks

✓Sort your data in descending order to create a naturally flowing funnel effect that readers understand immediately.
✓Use contrasting colors for each cone segment to improve clarity and make data comparison easier.
✓Keep category labels brief (under 15 characters) to prevent text overflow and maintain clean chart appearance.
✓Apply data labels (Chart Design > Add Chart Element > Data Labels) to show exact values on each cone segment.

Pro Tips

★Normalize your data so the largest value equals 100; this creates proportional cone heights that accurately represent percentage relationships.
★Use conditional formatting on source data to highlight which rows feed the chart, making data traceability transparent to viewers.
★Combine cone charts with a legend showing stage conversion rates; this adds analytical depth to funnel visualizations.
★Export cone charts as images (right-click > Save as Picture) for presentations, as some email clients don't support embedded Excel files.

Troubleshooting

Cone chart not appearing in chart type options

Ensure you have Excel 2016 or later (cone charts unavailable in earlier versions). If using Excel Online, cone charts may not display; download the desktop version. Verify your data selection includes both headers and values.

Cone heights appear disproportionate to data values

Right-click the chart > Format Data Series > Series Options. Check if 3D perspective is exaggerated; adjust the 3D rotation settings under Format > 3-D Rotation to reduce visual distortion.

Chart title or axis labels are cut off

Click the chart border to select it, then drag the corner handles to enlarge the chart area. Alternatively, right-click the axis > Format Axis > Text Options and reduce font size from 11pt to 9pt.

Data labels overlap or are unreadable

Right-click data labels > Format Data Labels > Label Options. Select 'Best Fit' for positioning, or change label position to 'Outside End' if overlap persists.

Related Excel Formulas

SUM COUNT AVERAGE PERCENTILE

Frequently Asked Questions

Can I create a cone chart in Excel Online?

Excel Online does not support cone charts natively. You must use the desktop version (Excel 2016 or later) to create cone charts. After creating in desktop Excel, you can upload the file to OneDrive and view it online, though editing options are limited.

What's the difference between cone, cylinder, and pyramid charts?

Cone charts use conical (cone-shaped) shapes, cylinder charts use cylindrical shapes, and pyramid charts use triangular pyramid shapes. All three are variations of 3D column charts used for different visual aesthetics; functionality and data representation are identical.

How do I make the cone chart show percentages instead of absolute numbers?

Right-click data labels > Format Data Labels > Number > Category: Percentage. Set decimal places to 1. Ensure your source data totals 100 or normalize it first by dividing each value by the sum of all values multiplied by 100.

Can cone charts display negative values?

No, cone charts cannot display negative values. If your data contains negatives, convert them to absolute values, use a column or bar chart instead, or separate negative data into a different series.

How do I export a cone chart for a presentation?

Right-click the chart > Save as Picture > Choose format (PNG for web, JPG for email, PDF for printing). This creates a static image you can insert into PowerPoint or other applications without Excel dependency.