Access Charts

[cdborg]

I am working with a survey database where one field represents one question in the Survey. Some questions allow the user to enter multiple answers. This data isn't normalized but I have to work with what I've got. Anyway I tried to create a chart in Access with the wizard but got the error: "Cannot have more than 6 elements in the chart". Anyway I attempted to recreate the chart
in Excel but my chart looks crammed and cannot print entirely within one page. Does anyone know how or have an
example of how to create a bar chart with many elements in a clear and consice manner.

Thanks so much for you time.

 

[misscrf]

I have been taught ( by dhookm) that you can just do the chart, let it only put in the 6 fields. Then in the design, click on the chart, and go to it's properties. Go to its rowsource and add the remaining rows that you would like.

You will probably need to go landscape with small margins. Dhook also suggests that you copy the chart design into a form design and use that to get the appearance right. Then just copy and paste back to the report to go live.

Hope that helps.

misscrf

Management is doing things right, leadership is doing the right things