Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
juamig
 
Posts: n/a
Default How to change plot area size of pivot chart

I have not been able to find a way to change the size of the plot area of a
pivot chart. Is there a way to do this?
thx,
Jua
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How to change plot area size of pivot chart

No, not without stretching the entire chart. This is one of the limitations
of pivot charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"juamig" wrote in message
...
I have not been able to find a way to change the size of the plot area of a
pivot chart. Is there a way to do this?
thx,
Jua



  #3   Report Post  
Posted to microsoft.public.excel.charting
juamig
 
Posts: n/a
Default How to change plot area size of pivot chart

How would I stretch the entire chart?
Jua

"Jon Peltier" wrote:

No, not without stretching the entire chart. This is one of the limitations
of pivot charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"juamig" wrote in message
...
I have not been able to find a way to change the size of the plot area of a
pivot chart. Is there a way to do this?
thx,
Jua




  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How to change plot area size of pivot chart

If it's embedded in a worksheet, just select it and drag the little black
handles. If it's a chart sheet, you can't. But you can create a regular
chart from the data. Select a cell away from the pivot table and start the
chart wizard. In step 2, switch to the series tab, and add the series one by
one (otherwise, Excel converts the chart to a pivot chart).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"juamig" wrote in message
...
How would I stretch the entire chart?
Jua

"Jon Peltier" wrote:

No, not without stretching the entire chart. This is one of the
limitations
of pivot charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"juamig" wrote in message
...
I have not been able to find a way to change the size of the plot area
of a
pivot chart. Is there a way to do this?
thx,
Jua






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't change source data path for Pivot Chart Mike B in VT Charts and Charting in Excel 1 February 19th 06 12:43 AM
Change the size of a chart marker in the legend Thea Charts and Charting in Excel 0 February 13th 06 09:38 PM
chart size zdenek Charts and Charting in Excel 0 February 9th 06 10:58 AM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 05:45 PM
Prevent change of color scheme in Pivot chart Bernd Charts and Charting in Excel 1 February 10th 05 08:12 PM


All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"