Change Chart Object Problem

B

Bill Sturdevant

I have a chart object on a form. I use the following code
to change the values of the bars on the chart:

Dim chtObj As Object
Set chtObj = Me![Evaluation Results Graph].Object
chtObj.Application.datasheet.cells(2, 1).Value =
overallPointAverage
chtObj.seriesCollection(1).Points(1).Interior.Color =
QBColor(intValue)


The reference to ".datasheet.cells(2, 1).Value" works for
every bar except the first one.

Is there a known problem or a way around this?
 

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