Problem With Graph Labels

[crhodus]

I have a table that is being created each time by a query named MyTable. In this table are 2 fields: CountyName and NumVisits. The CountyName field contains the county name and the NumVisits contains a numeric value.

I inserted a Microsoft Graph 2000 unbound frame object into my report. I then selected "Table/Query" for my Row Source Type and I selected "MyTable" as the RowSource.

When the report runs, it looks good. It shows a different colored bar for each county. In the legend, a colored box with the county name appears.

My problem is that I want each county name to appear vertically under each bar on the graph. The only thing that appears under one of my bars is the number five, which is the first value in the NumVisits column in my table.

I've tried playing around with the data sheet that appears when you are editing a graph, but I've had no luck getting the correct county name to appear. Can anyone tell me what I'm doing wrong?

Thanks,
Crhodus

 

[rbrule]

Try changing the focus of the chart from by column to by row. In design view right click on the chart and choose chart object> edit. The datasheet view will show, as well as a menu bar at the top. You can switch focus by clicking either the by column or by row button. When you do this, the view of the chart in design view will not accurately show the chart results, but the actual chart will show the results.

 

[crhodus]

Thanks! That seems to have done the trick.