Multiple Series Line Chart (OWC10)

J

Jason Chan

Let say I have quarter sales data from 2003 Q2 to 2005 Q2

i.e 2003 Q2, Q3, Q4 sales are 100, 200, 300 respectively
and 2004 Q1, Q2, Q3, Q4 sales are 400, 500, 600 and 700 respectively
and 2005 Q1 and Q2 sales are 800 and 900 respectively

I want to create a 3 lines chart with each line per year

The first line will be 2003 and the data start at Q2, so it should be no
marker in 2003 Q1
The second line should be a full line with 4 markers representing Q1 to Q4
and the last line is 2005 with 2 markers in Q1 and Q2

The problem is in the first line.
So can i programmingly make in no marker in 2003 Q1?

I throught it will work but it doesn't

Set Sales2003 = Array(null, 100, 200, 300)
Chart.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, Sales2003

It will automatically shift the data to the left. In simple excel, if i
leave the cell empty, it will made no data in that point.
How can i do it in OWC 10? I am developing a asp application to export the
chart to gif.

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top