Charting Problem

[James 'Smiler' Farrer]

Hi,

I want to re-produce the graph shown here
(http://www.smiler.me.uk/graph.gif) using the office web components.

I currently have a recordset with the site, month, and frequency.

I can plot site to frequency fine, but not incorporating the dates.

Any assistance appreciated.

Regards

James

 

[James 'Smiler' Farrer]

Ok I have done this and get a blank graph....

Set oChartSpace = CreateObject("OWC.Chart")
Set goConstants = oChartSpace.Constants
set c = oChartSpace.Constants
oChartSpace.Border.Color = goConstants.chColorNone
set oChartSpace.DataSource = objRS
Set oChart = oChartSpace.Charts.Add
oChart.Type = c.chChartTypeBarClustered
FormatChart oChart, "Stoppage Duration By " + Grouping, Grouping, "Total
Duration (hrs)", "#,##.##"
oChart.SetData chDimSeriesNames, 0, Grouping
oChart.SetData chDimCategories, 0, "KeyDate"
oChart.SetData chDimValues, 0, "Duration"

Grouping is another db field loaded from a different query....