How to build 2 axes stacked column chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

halfofme_j - 23 Apr 2007 13:48 GMT

I am trying to build a single stacked cylinder chart displaying data in terms
of $ value and counts. I would like to have each variable displayed as a
stacked cylinder (or column) against its own axis. Any asiisitance is
appreciated

Reply to this Message

Echo S - 23 Apr 2007 15:27 GMT

Insert | Chart, right-click and choose Chart Type. Select the Stacked
Column.

Right-click a data series, choose Format Data Series. On the Axis tab, click
Secondary Axis.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

>I am trying to build a single stacked cylinder chart displaying data in
>terms
> of $ value and counts. I would like to have each variable displayed as a
> stacked cylinder (or column) against its own axis. Any asiisitance is
> appreciated

Reply to this Message

Andy Pope - 23 Apr 2007 16:49 GMT

Hi,

If you are using MSGraph.
http://www.andypope.info/ngs/ng28.htm

You will have to use 2d column types so no cylinders.

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message