Clustered Column Chart with Second Axis

You need to use some extra series:

Orchard Traditional Orch% Trad%
Cash Outlay 600,000 500,000
Cash Returned 1,550,805 635,219
Capital Gain 950,805 135,219
Gross Return (%) 158.5% 27.0%
Annualized Return (%) 26.8% 6.2%

Plot these four series as a clustered column chart. Double click the
Orch% series, select Secondary on the Axis tab. Select the Trad% series
and press F4 to repeat.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

gurs wrote:

I have a clustered column chart with 5 sets of A-B data, as follows:


Code:
--------------------
Orchard Traditional
Cash Outlay 600,000 500,000
Cash Returned 1,550,805 635,219
Capital Gain 950,805 135,219
Gross Return (%) 158.5% 27.0%
Annualized Return (%) 26.8% 6.2%
--------------------


I want to do a clustered column chart comparing the two data series
("Orchard" and "Traditional") for each category ("Cash Outlay", "Cash
Returned", etc.). However, since the last 2 categories are
percentages, they don't show up on the chart. When I try to add a
second axis to the chart, I can only add the second axis for an entire
data series (either "Orchard" or "Traditional"). I can't figure out
how to make the last 2 categories for both data series refer to the
second axis, while the first 3 categories for both data series refer to
the primary axis. Is it possible to have part of a data series graphed
on one axis and part on another?

Thanks for your help!


---
Message posted from http://www.ExcelForum.com/