ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   resize chart (https://www.excelbanter.com/charts-charting-excel/172755-resize-chart.html)

Souris

resize chart
 
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,

ShaneDevenshire

resize chart
 

--
Thanks,
Shane Devenshire


"Souris" wrote:

I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,


ShaneDevenshire

resize chart
 
Sorry about that last post...

Yes Excel lets you resize charts. What version of Excel are you using 2007
or earlier? Where is your chart located - a chart page or on a worksheet?
Is this a regular chart or a pivot chart? Are you trying to resize the plot
area or the entire chart?

On a worksheet, you can resize the chart by dragging the sizing handles on
the border.
--
Cheers,
Shane Devenshire


"Souris" wrote:

I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,


Jon Peltier

resize chart
 
Based on your other post, I assume you're talking about a pivot chart. In
Excel 2000 through 2003, there was little flexibility in the formatting of
pivot charts. Various elements of a pivot chart cannot be moved or resized.

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


"Souris" wrote in message
...
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,




ShaneDevenshire

resize chart
 
Hi,

It is just as Jon says. You would not be able to size the plot area but you
can resize the chart.

--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

Based on your other post, I assume you're talking about a pivot chart. In
Excel 2000 through 2003, there was little flexibility in the formatting of
pivot charts. Various elements of a pivot chart cannot be moved or resized.

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


"Souris" wrote in message
...
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,





Souris

resize chart
 
Thanks for helping,

"ShaneDevenshire" wrote:

Hi,

It is just as Jon says. You would not be able to size the plot area but you
can resize the chart.

--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

Based on your other post, I assume you're talking about a pivot chart. In
Excel 2000 through 2003, there was little flexibility in the formatting of
pivot charts. Various elements of a pivot chart cannot be moved or resized.

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


"Souris" wrote in message
...
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,





Souris

resize chart
 
Thanks for the information,

I use Access 2003 and have a pivotchart on chart sheet.
I am able to resize the chart on the regular sheets, but not the pivotchart
on chart sheets.

I just wanted to enlarge the chart by draging the border of plot area, but
it does not work. Is it the limitation of pivotchart?

Your information is great appreciated,

"Jon Peltier" wrote:

Based on your other post, I assume you're talking about a pivot chart. In
Excel 2000 through 2003, there was little flexibility in the formatting of
pivot charts. Various elements of a pivot chart cannot be moved or resized.

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


"Souris" wrote in message
...
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,





Jon Peltier

resize chart
 
That is one of the limits of a pivot chart. You can get around it by using a
regular chart, but that will not pivot properly with the pivot table, unless
the pivot table's dimensions are unchanged:

Pivot Tables, Pivot Charts, and Real Charts
http://pubs.logicalexpressions.com/P...cle.asp?ID=553

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


"Souris" wrote in message
...
Thanks for the information,

I use Access 2003 and have a pivotchart on chart sheet.
I am able to resize the chart on the regular sheets, but not the
pivotchart
on chart sheets.

I just wanted to enlarge the chart by draging the border of plot area, but
it does not work. Is it the limitation of pivotchart?

Your information is great appreciated,

"Jon Peltier" wrote:

Based on your other post, I assume you're talking about a pivot chart. In
Excel 2000 through 2003, there was little flexibility in the formatting
of
pivot charts. Various elements of a pivot chart cannot be moved or
resized.

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


"Souris" wrote in message
...
I tried to drag to resize the chart which does not work.

I would like to know that does excel chart supports resize?

If yes, how can I do it?

Your information is great appreciated,








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

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