2-y axis line chart

[oldLearner57]

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

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Jon Peltier]

Here are my suggestions, in order:

1. Use two different line charts.
2. Make a panel chart with prices in the top panel and volume in the bottom:
http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

- Jon

 

[oldLearner57]

10s for the site url
--
oldLearner57

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

--
HTH

Bob

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

 

[oldLearner57]

10s for the url site and guidance



10s community as well