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