Scatter chart using Java script

madganesh · June 13th, 2007, 05:03 AM

Dear all,
I have tried to create a scatter chart using Javascript and Microsoft OWC. For some reason, this one fails. This does work for column charts . Can you pleae advise on this?

<html>
<head>
</head>

<script type='text/javascript'>

function create_chart() {

  var xlLineMarkers = 21;
  var xlColumns = 2;

  var chDimSeriesNames = 0;
  var chDimCategories = 1;
  var chDimValues = 2;
  var chDimXValues = 4;
  var chDimYValues = 4;

  chart.Charts.Add();

  chart.ChartType = xlLineMarkers;
    chart.DataSource = excel;//.Range("A1:B12");
    var s = chart.Charts(0).SeriesCollection;

    var data_series = s.Add();
    data_series.caption = 'Monkey'.

    data_series.SetData(4, 0, "A1:A12");
    data_series.SetData(3, 0, "B1:B12");

  return false;
}

function l() {

  excel.DisplayToolbar = false;

  excel.range('a1:a12').select();
  excel.Selection.NumberFormat = 'mmm-yy';

  excel.range('a1' ).value = 'Jan-2004'
  excel.range('a2' ).value = 'Feb-2004'
  excel.range('a3' ).value = 'Mar-2004'
  excel.range('a4' ).value = 'Apr-2004'
  excel.range('a5' ).value = 'May-2004'
  excel.range('a6' ).value = 'Jun-2004'
  excel.range('a7' ).value = 'Jul-2004'
  excel.range('a8' ).value = 'Aug-2004'
  excel.range('a9' ).value = 'Sep-2004'
  excel.range('a10').value = 'Oct-2004'
  excel.range('a11').value = 'Nov-2004'
  excel.range('a12').value = 'Dec-2004'

  excel.range('b1' ).value = 10
  excel.range('b2' ).value = 15
  excel.range('b3' ).value = 18
  excel.range('b4' ).value = 17
  excel.range('b5' ).value = 20
  excel.range('b6' ).value = 23
  excel.range('b7' ).value = 22
  excel.range('b8' ).value = 24
  excel.range('b9' ).value = 27
  excel.range('b10').value = 27
  excel.range('b11').value = 29
  excel.range('b12').value = 32
}
</script>

<body onLoad='l();'>

<form>
  <input type=submit onclick='return create_chart()' value='Create Chart'>
</form>

<object
  id = excel
  classid = 'clsid:0002E551-0000-0000-C000-000000000046'
  name=excel>

<param name=DisplayTitleBar value=false >
<param name=ViewableRange value='a1:b12'>
<param name=AutoFit value=true >
</object>

<object id= chart classid='clsid:0002E556-0000-0000-C000-000000000046' style="width:100%;height:350"></object>

</body>
</html>

zaerymoghaddam · June 17th, 2007, 06:48 AM

At first I should mention that you have a syntax error in your code (data_series.caption = 'Monkey'.)
What is that period after 'Monkey' string ? But after removing this little syntax error, your code still have some problems. You used 21 as a chart type number (meaning ScatterMarkers chart). The main problem raises when you try to call data_series.SetData(4, 0, "A1:A12"); or data_series.SetData(3, 0, "B1:B12");.

You are using number 3 and 4 as a first parameter of these methods and these are wrong number for charts like this. If you use 2 and 1 (instead of 3 and 4) correspondingly, you will have your little pretty chart without any problem.

Good luck