How to change plot area size of pivot chart

juamig · 05-09-2006, 07:35 PM

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 · 05-09-2006, 11:10 PM

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" <[email protected]> wrote in message
news:[email protected]...
>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 · 05-10-2006, 02:10 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> >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 · 05-11-2006, 07:20 AM

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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** · 02-13-2016, 10:31 PM

In Excel 2007, Microsoft upgraded Pivot Charts substantially, so that they behave much more like regular charts. For example, you can now resize the individual elements of a pivot chart without stretching the entire chart.