Can I create a pivot chart on the same sheet as my pivot table?


Problem

By default, Excel creates all pivot charts on their own worksheet. However, you can get around this default and create a pivot chart on the same worksheet as your pivot table.

Solution

Place your cursor in a cell outside your pivot table and launch Excel's Chart Wizard. In step 1 of the wizard, select the type of chart you want to use. In step 2 of the wizard, click on your pivot table and then click Finish. A new pivot chart will be created on your worksheet, just as a normal chart would. All you have to do at this point is format the chart.



    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net