is there any options or macros avialable for creating multiple y axis in the
xy chart.
my application is that i want plot a graph for various values at a time as
the list below

x y1 y2 y3 y4
10.00pm 0.5 1000 10 50
10.30 pm 0.6 1200 20 150

like the above datas the scale in y1 axis is 0 to 1.0 and y2 axis is 0 to
1200. and y3 is o to 50 and y4 is o to 250

in the excel the possibilites are only two y axis can be drawn how to
include third and fourth y axis

can any one help me out
--
sivaprakasam

Take a look he
http://peltiertech.com/Excel/Charts/axes.html#TertAxis

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"sivaprakasam" wrote:

is there any options or macros avialable for creating multiple y axis in the
xy chart.
my application is that i want plot a graph for various values at a time as
the list below

x y1 y2 y3 y4
10.00pm 0.5 1000 10 50
10.30 pm 0.6 1200 20 150

like the above datas the scale in y1 axis is 0 to 1.0 and y2 axis is 0 to
1200. and y3 is o to 50 and y4 is o to 250

in the excel the possibilites are only two y axis can be drawn how to
include third and fourth y axis

can any one help me out
--
sivaprakasam

Jon shows how to fake a third y-axis at
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

If I had this problem, I would used a primary and a secondary axis and scale
some of my y-values so that all four series would show up on the chart
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"sivaprakasam" wrote in message
...
is there any options or macros avialable for creating multiple y axis in
the
xy chart.
my application is that i want plot a graph for various values at a time as
the list below

x y1 y2 y3 y4
10.00pm 0.5 1000 10 50
10.30 pm 0.6 1200 20 150

like the above datas the scale in y1 axis is 0 to 1.0 and y2 axis is 0 to
1200. and y3 is o to 50 and y4 is o to 250

in the excel the possibilites are only two y axis can be drawn how to
include third and fourth y axis

can any one help me out
--
sivaprakasam

thank you for the post

but i need multiple y axis should be shown in my graph example there should
be one x axis and three y axis in chart showing their respective scalings,
from excel options only primary and secondary axis can be shown and the datas
will be plotted based on this primary and secondary axis only , how to
include the thrid axis and show it chart and plot a series based on that y
axis,

there is software called multi-y axis from www.officeexpander.com but i
think there will some other solution from microsoft

hope i am not confusing , if any one cannont understand please let me know

--
sivaprakasam


"sivaprakasam" wrote:

is there any options or macros avialable for creating multiple y axis in the
xy chart.
my application is that i want plot a graph for various values at a time as
the list below

x y1 y2 y3 y4
10.00pm 0.5 1000 10 50
10.30 pm 0.6 1200 20 150

like the above datas the scale in y1 axis is 0 to 1.0 and y2 axis is 0 to
1200. and y3 is o to 50 and y4 is o to 250

in the excel the possibilites are only two y axis can be drawn how to
include third and fourth y axis

can any one help me out
--
sivaprakasam