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.
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.