Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart Created from Pivot Table is Blank
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart Created from Pivot Table is Blank
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 -- If this helps, please click the Yes button Cheers, Shane Devenshire "RaidersFan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get SQL from Created Pivot table | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Is Data Needed After Pivot Table is Created? | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
pivot table created from another pivot table | Excel Worksheet Functions |