Stacked Columns and TWO axis

[Ed Pereira]

Does any one know how to add a second Y axis to a stacked
column chart?
When one charts revenue and profit, and the profit is just
a small percentage of the revenue, the impact of the
profit distribution by category is lost because the scale
on the Y axis measuring the revenue. Any help is greatly
appreciated.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Ed Pereira.
Please use the newsgroup for further discussion.]

Plot both series on both axes. How? Plot the series as normally so
that both are on the primary axis. Then, select the 2 ranges on the
worksheet and drag onto the chart. In the resulting dialog box ensure
they are plotted as new series. For each of these new series, set the
axis to 'Secondary.'

Then, set one series (say Profit) on the primary axis to transparent
(double-click it, then in the Patterns tab set both Border and Area to
None). Do the same for the *other* series (say Revenue) plotted on the
*other* axis.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions