How to enlarge stacked chart plot area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In most chart types, I can grab a corner and the chart will expand as I pull
it. Not so with 100% stacked chart. How can I make it larger than 1/4 of
the page?

TIA
Carole
 
Is it a pivot chart? The inability to resize the plot area of pivot
charts is yet another reason I rarely use them.

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

No it isn't a pivot chart. This is what I'm working with. I just want to
make the chart part bigger.

FRESCO VINYL STICK ANYWHERE CANVAS CUSTOM MISC
PROD 7867 63 0 0 48
SCRAP 1216 0 0 0 0

TIA, Carole O
 
There's nothing special about your data. I just pasted it into a
worksheet, created two stacked column charts (one embedded chart, one
standalone chart sheet), and I could resize the charts at will.

Has your chart been protected?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon - I thought I stated that I'm working with the 100% 3D chart - and see
now that I didn't. It's the 3D part that isn't resizing. Sorry for wasting
your time earlier!

Carole O
 
I like 3D charts even less than Pivot Charts. Several of the 3D chart
types, including the surface and contour charts, like to enforce a
"square" grid pattern, so you could change the size of the plot area,
but not the aspect ratio.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
I gave up - made it a flat chart instead. Oh, well - we tried!!

Thanks for your help and punctuality!!

Carole O
 
Back
Top