ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to change plot area size of pivot chart (https://www.excelbanter.com/charts-charting-excel/87781-how-change-plot-area-size-pivot-chart.html)

juamig

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

Jon Peltier

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




juamig

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





Jon Peltier

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








All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com