How do you get a field into the data area of a Chart?

J

john.kaye

I am new to using the OWC Charts and have created a pivot table from a
record set. When I try to create a graph from the same record set I
can get the filter and category sections working but there is no data
in the chart. The step that is missing is to add
"AssignmentRemainingWork" into the data area which I can do in Internet
Explorer using the chart field list feature but I cannot do it in code.
What am I doing wrong? The relevant piece of code is:
set c = ChartSpace1.Constants
cht.Type = c.chChartTypeColumnClustered

ChartSpace1.SetData c.chDimFilter, c.chDataBound,
"AssignmentResourceName"
ChartSpace1.SetData c.chDimCategories, c.chDataBound,
"AssignmentStart"
ChartSpace1.SetData c.chDimValues, c.chDataBound,
"AssignmentRemainingWork"

Internet Explorer errors on the last statement (DimValues)
Thanks in advance for your help.
Best Wishes, John
 
J

john.kaye

I have just found out that I was missing the line:
ChartSpace1.HasPlotDetails = true
Best Wishes, John
 

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