CodeProject: Simple Charts Using OWC (Office Web Component). Free source code and programming help

This is a simple project for beginners to get some knowledge about using OWC in a C#.NET application for chart representation.

Background

Using the code

Steps

Points of Interest

I hope you've enjoyed this little tutorial. In future, I will provide you lot more stuff. And I am expecting your valuable suggestions.

You must Sign In to use this message board.


Per page

FirstPrevNext

in vb6

deepakmathur

21:45 11 Dec '08

Code Unavailable

sysengineer

0:47 15 Mar '08

OWC scatter chart error

ganesh_india

4:24 13 Jun '07

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 önLoad='l();'>

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

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

</object>

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

</body>
</html>

3.00/5

dynamically add

superda

22:16 15 Apr '07