Pivot Chart Created from Pivot Table is Blank

  • Thread starter Thread starter RaidersFan
  • Start date Start date
R

RaidersFan

HELP!!! I am following a tutorial in an Excel 2007 book step-by-step. In
one of the lessons I was able to successfully and easily create a pivot chart
from a pivot table. In my next lesson, I am following the exact same steps
(even have started over a couple of times), and when I create a pivot chart
from the pivot table in this lesson, it creates a blank chart. WHY DOES IT
DO THIS??? I know I have followed the steps correctly. Any ideas on why
Excel isn't cooperating with me on this lesson would be soooo appreciated.
 
Hi,

Blank charts usually result from having your cursor in a blank area when you
start.

1. Put the cursor in the pivot table
2. Choose Insert, and pick a chart type.

Done.

Second way:
1. Put the cursor in the pivot table
2. Choose PivotTable Tools tab, Options tab, PivotChart, pick a chart type
and click OK.

Done

Third way:
1. Put the cursor in the pivot table
2. Press Alt+F1

Fourth way:
1. Put the cursor in the pivot table
2. Press F11
 
Back
Top