Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2006
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Resizing Pivot Charts (Excel 2003)

    I've got some pivot charts created with corresponding pivot tables. Each chart is on its own worksheet. As displayed there, the chart does not take up the entire width of the sheet, but it is sized so that it is too big to see its entire height. Is there some way for me to resize these charts so they fit properly? There are buttons at the top to select fields, and a button at the bottom to select other fields, and it is not possible to see both at once.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Resizing Pivot Charts (Excel 2003)

    Make sure that "Chart Area" is selected in the Chart Objects dropdown on the Chart toolbar.
    Click in the Zoom box in the Standard toolbar, and select Fit to Selection from the dropdown list. Or experiment with entering percentages yourself (you're not limited to those in the list).

  3. #3
    Lounger
    Join Date
    Nov 2006
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resizing Pivot Charts (Excel 2003)

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •