Chart & Visualization Issues

Fix Unavailable Recommended Charts for an Excel PivotTable Histogram

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 868 views

Question details

The user needs to create a histogram-like or Pareto-style chart from Excel PivotTable results when Recommended Charts is unavailable.

Fix Unavailable Recommended Charts for an Excel PivotTable Histogram
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user has summarized data in a PivotTable and wants to visualize the bin labels and counts as a histogram or similar chart.
Observed behavior
Excel does not provide Recommended Charts for the PivotTable data, and it cannot directly create Histogram or Pareto charts from a PivotTable.
Before you start

Confirm that the PivotTable already contains the category or bin labels and the corresponding values to plot. If the PivotTable may be refreshed, create a linked helper range rather than using a one-time pasted copy.

Solution 1Recommended

Create a chart from a linked PivotTable results range

Use this method when you need the chart to reflect PivotTable results while avoiding Excel's PivotTable chart-type limitation.

Excel cannot directly create Histogram or Pareto charts from PivotTable data, including in Windows versions. Put the PivotTable output into a standard worksheet range first, then create the chart from that range.

1
Create a helper range

On a blank area of the worksheet or a new sheet, enter cell-reference formulas that point to the PivotTable labels and values, such as =A5 and =B5. Copy the formulas down for all displayed PivotTable rows.

2
Select the helper data

Select both the label column and the value column in the helper range, including the headers if you want Excel to use them as chart labels.

3
Insert a chart

On the Excel ribbon, select Insert > Recommended Charts. If a Histogram option is available for the normal range, choose it; otherwise select Insert > Column or Bar Chart > Clustered Column.

4
Make a column chart resemble a histogram

Click a data column, then open Format Data Series > Series Options and reduce Gap Width, such as to 0% or a small value, so adjacent columns touch or nearly touch.

Create a chart from a linked PivotTable results range
Use a standard range as the chart source: A normal worksheet range can be used for chart types that are unavailable when the source is a PivotTable.
Create charts from PivotTable results

Build a Histogram-Style Chart from PivotTable Results in WPS Spreadsheets

WPS Spreadsheets lets you place PivotTable results in a normal worksheet range and create a column chart from those labels and values. Adjust the series gap width to present grouped counts as a clear histogram-style chart.

  1. 1. Prepare the PivotTable summary: In WPS Spreadsheets, create or open the PivotTable that contains the bin labels and count values you want to chart.
  2. 2. Create a regular helper range: In empty cells, reference the PivotTable label and value cells with formulas, or copy the displayed results and use Home > Paste > Values.
  3. 3. Insert a column chart: Select the helper range, then choose Insert > Chart > Column and select a clustered column chart.
  4. 4. Reduce the column gap: Click a chart column, open the chart formatting options, and reduce the Gap Width setting to produce a histogram-style layout.
Create column charts from PivotTable result ranges for histogram-style reporting.Adjust chart series spacing to make value columns touch or nearly touch.Open and edit Microsoft Excel .xlsx and .xls workbooks.Use a familiar spreadsheet interface for PivotTables, formulas, and charts.
microsoft office alternative - wps office

Frequently Asked Questions

Why are Recommended Charts unavailable for my Excel PivotTable?

Excel limits some chart types when the source is a PivotTable. Histogram and Pareto charts cannot be created directly from PivotTable data, so Recommended Charts may not offer them.

Can I create a true histogram from PivotTable counts?

If the PivotTable already contains bins and counts, use a clustered column chart from a normal helper range and reduce Gap Width. This displays the grouped counts in a histogram-style format.

How can I keep a chart connected to refreshed PivotTable data?

Create a helper range with formulas that reference the PivotTable output, then base the chart on that helper range. Update the formulas or referenced range if the PivotTable layout changes.

Can I make a Pareto chart directly from a PivotTable in Excel?

No. Create a regular range from the PivotTable results first, then build a column chart and add a cumulative-percentage line if you need a Pareto-style chart.