View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Stacked Column Chart - Decrease height of columns

Go to Chart menu Chart Type, and the selected chart type and subtype will
be highlighted. Change to the same subtype, except without the 3D effects.

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


"Fenil Shah" wrote in message
...
Thank You, Sir! It worked. Btw, I know this must sound extremely dumb, but
how do I go about changing it to 2-D?

Regards,
Fenil.

"Jon Peltier" wrote:

Increase the Y axis maximum so that the columns do not reach so high.

If you're adding textboxes, make sure you select the chart before adding
the
textboxes, so they are embedded in the chart, rather than in the
worksheet.
Also you will be well served to change to a 2D chart, otherwise it will
soon
become very cluttered.

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


"Fenil Shah" wrote in message
...
I have this stacked column shart with 3-D visual effect, in which I
would
like to decrease the height of the columns vis-vis the plot area as I
need
to
insert text boxes in the plot area over the columns. How do I go about
it?
Can somebody pl. help me with this?

Fenil.