Chart Wizard Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was trying to create a chart from a crosstab query that contains a date
field as a row heading, calculation as a value, and a text field as a column
heading. When I tried to create the chart using the wizard, I get the
following error:

"Either the table or query you selected doesn't have enough valid fields to
provide data for a chart or the fields can't be retrieved. Select a table or
query with at least one numeric, date, or test field."

I have never seen this error before. Any suggestions?
 
Mooney:

Have you set the column headings property for the cross tab query so that it
has fixed field headings? You need that otherwise Access can't retrieve the
fields to place on the chart.
 
SA:

I hate to admit it but I don't know how to set the column headings property.
Can you help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Chart Error-Select a table or query with at least one numeric, date, or 3
Problem creating Graph from Chart Wizard 3
Bar chart question 1
chart using query with between 1
Link chart to report 4
Trouble with Simple Pie Chart 1
Code to create graphs 1
Pie chart troubles 9

Back
Top