Selecting the series for a chart

[Board2Death]

Access 97

I have a report that contains a bar chart. I want to display the values from the query on each bar to one decimal place.

I have several similar reports. On some reports the OLE Class for the chart is Microsoft Graph Chart and on some it is Microsoft Graph 97 Chart. I don't know why they are not all the same.

On the charts where the OLE Class is Microsoft Graph Chart I can select the series.
On the charts where the OLE Class is Microsoft Graph 97 Chart I cannot select the series.

In order to modify the number formatting, I need to be able to select the series. Any ideas why the different OLE Classes and why I cannot select the series for those charts where the OLE Class is for 97? Is there any way to change the OLE Class? Or is there any way to select the series for the 97 class?

 

[Darrylles]

Hi,

In any VBA code module look at Tools -> References. You should have 2 'chart' references in there - delete the one not needed.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.