[Method DataSourceADO failed for _Chart]

Since I couldn't find the true answer to this problem, I created the following workaround:

I created a second chart and assigned the second ADO recordset equal to the chart's DataSourceADO property. I then had logic in my code that decided which chart should be visible and which one should not. If anyone has a better workaround or the answer to the original question, please feel free to post it.

Thanks,

Patrick

[How to get no decimal places for pie chart data]

I found out the answer by doing a bit more research. In case anyone is interested, here is how it is done.

'## Note that my label data was on the first axis, hence .Axis(0).

Chart.Axis(0).LabelsFormat.Decimals = 0

[How to get no decimal places for pie chart data]

Hello,

I am using ChartFX 6.2 COM version.

When I have a pie chart, I call the following two methods to display the data percentage point values assigned to each point of the pie:

.PointLables = True

.PointLabelMask = "%p"

However, the percentage values always show two decimal places. What do I need to do get the data to show a different number of decimal places (i.e. one or none)?

Thanks,

Patrick

[Method DataSourceADO failed for _Chart]

Hello,

I am using ChartFX 6.2 COM version.

I have a chart in which I dynamically assign an ADO recordset to the the chart's DataSourceADO property. However, after doing some data processing, sometimes I have to assign a different recordset to the DataSourceADO property. When I do this, I get the error "Method DataSourceADO failed for _Chart".

Can someone tell me the best way to assign a recordset after I have already assigned a first one? By this I mean that I want the chart to start using the second recordset instead of the first recordset.

Thanks,

Patrick