Clustered Column Chart with Second Axis

  • Thread starter Thread starter gurs
  • Start date Start date
G

gurs

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
 
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
 
Back
Top