User (Legacy) Posted July 28, 2000 Report Share Posted July 28, 2000 Hello all: I have a recordset which contains 5 columns x 12 rows of data. the first column is for X-axis. the 2nd and 3rd column are percentage. and 4th and 5th column are quantities. I want to use a dual Y-axis chart to represent the data (the left Y-axis is used for two percentage series and the right Y-axis is used for two Quantity series. What I want eventually is a chart with two lines for percentages and two bars for quantities). My problem seemed to be I don't know how to assign FOUR series to TWO Y-AXIS (TWO series for each ONE Y-AXIS). I read through the help and only got how to assign one series to one axis. it doesn't seem working if I say: set chart=Server.CreateObject("ChartFX.WebServer") ... Chart.ADOResultset rstTrend .. chart.MultiType(0)=xxx ---> 'for 'line and dot' type chart.MultiType(1)=xxx ---> 'for 'line and dot' type chart.MultiType(2)=yyy ---> 'for 'bar' type chart.MultiType(3)=yyy ---> 'for 'bar' type chart.MultiYAxis(0)=1 ---> ' assign 2nd series to left Y-Axis chart.MultiYAxis(0)=2 ---> ' assign 3rd series to left Y-Axis chart.MultiYAxis(1)=3 ---> ' assign 4th series to right Y-Axis chart.MultiYAxis(1)=4 ---> ' assign 5th series to right Y-Axis ... What did I do wrong? I guess that is what I am actually looking for. Thank you for your attention. ---yang Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.