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 serie
("Orchard" and "Traditional") for each category ("Cash Outlay", "Cas
Returned", etc.). However, since the last 2 categories ar
percentages, they don't show up on the chart. When I try to add
second axis to the chart, I can only add the second axis for an entir
data series (either "Orchard" or "Traditional"). I can't figure ou
how to make the last 2 categories for both data series refer to th
second axis, while the first 3 categories for both data series refer t
the primary axis. Is it possible to have part of a data series graphe
on one axis and part on another?

Thanks for your help

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

Never mind, figured it out

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

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/
>