Have a look at http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"oldLearner57" wrote in message
...
hi community

can anybody please guide me how am I to tabulate my data so that I can
chart
- 2 y-axes, example:

i have 5 set of stocks prices and their volume traded per day (recorded
for
25 days). I want to chart these 5 set of stock prices (y) on my left axis
and
volume traded on the right axis (y) against the day (x)

thanks for assistance given

thanks community :)
--
oldLearner57