- Check your Pivot Table layout
Double-check that the data in the Pivot Table is formatted correctly and that you don’t have any blank cells or unexpected spaces in the data.
- Check if the Pivot Chart is based on the correct Pivot Table Data
Make sure the Pivot Chart is based on the correct Pivot Table Data and has the right rows and columns selected.
- Check any Pivot Table Calculations
Check to see if there are any calculations applied to the Pivot Table that are causing the data to appear different in the chart.