Charts with more than 6 criteria

[Guest]

I am trying to build a report that charts the different sources our customers
are using to find out about our product. The survey they fill out has 14
different criteria. Access will only allow me to put 6 on a single chart.

Is there a way to "trick" Access into allowing more criteria? Or is it
possible to somehow link the query to Excel and have Excel automatically
create the chart?

I'm using Access and Excel 2003.

Thanks for the help

 

[Rick Brandt]

I am trying to build a report that charts the different sources our
customers are using to find out about our product. The survey they
fill out has 14 different criteria. Access will only allow me to put
6 on a single chart.

Is there a way to "trick" Access into allowing more criteria? Or is
it possible to somehow link the query to Excel and have Excel
automatically create the chart?

There is no such limitation on a chart in Access. The limtation is only in
the Chart Wizard you are using to create the chart. Just edit the chart
after creating it to add the additional fields.