Pie chart shows only one value. Why?

[jasonmac]

Hello everyone. I don't use access charts very often but for my current project I need to create several pie charts. I have a query that the report is based on. This query already sumarizes my data so I have 1 record. The query is called qrySummary and it has the following fields:
Internal
External
Closed
Void and several others.
For my first chart I need a pie chart that shows internal and external. When I go through the chart wizard I do not get the desired result. Not even close. I am becoming increasingly frustrated with this, I just don't seem to get it. Can anyone help??

Thanks in Advance,
Jason

 

[dhookom]

The Row Source query is what determines the graph values. I would expect your row source to return something like:

IntExt      Value
=========   ======
Internal     23.4
External     45.2

Duane
MS Access MVP
Find out how to get great answers faq219-2884.