Two charts on One Help Please

[J P Singh]

Does anyone know if I can do a chart in excel with two axis. I have two
kinds of data in excel. first is something like this

Company Amount
LP 78500
POP 45666
KLP 63255
JJK 45666

These are the amounts spent by these companies on advertising. The product
sales have grown by
Company Growth
LP 0.93%
POP 0.54%
KLP 0.23%
JJK 0.48%

I want to represent both sets of data in the same graph. Is that possible.
Please note that second set of data is not related to first set of data but
is the overall growth for that company. Can someone do me a favour and send
me a reply on email as well.

Thanks

Jas

jas.pa...@tsms.co.uk

[J P Singh]

follow up to my message my first data is in bar chart and the second is line
chart
J P Singh wrote in message ...

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a courtesy
email copy was sent to J P Singh <happy...@hotmail.com>. Please use the
newsgroup for further discussion.]

Chart the two series as in a bar chart. Select the 2nd series (with percentage
values) and change the chart type to line or xy scatter, using the menu item
Chart | Chart type...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--
In <Oe6xz#8o$GA.1228@cppssbbsa06>, J P Singh <happy...@hotmail.com> wrote