Fix Unavailable Recommended Charts for an Excel PivotTable Histogram
Question details
The user needs to create a histogram-like or Pareto-style chart from Excel PivotTable results when Recommended Charts is unavailable.

- 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.
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.
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.
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.
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.
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.
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.

Copy PivotTable values to a regular range for a one-time chart
Use this option when the PivotTable will not change or when you only need a static chart for a report.
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. 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. 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. Insert a column chart: Select the helper range, then choose Insert > Chart > Column and select a clustered column chart.
- 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.

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.




