A Simple Graph

[acent]

Has anyone been successful at creating a simple graph in Access 2007? I've been trying all day and haven't gotten this graph to work right.

I have a table of call logs. After washing the data though a couple queries, have the data displayed how I want it.

qryDialerPercentages (hourOfCall,TimeZone,percentage: successfulcount/totalcalls)

This gives me a nice query showing the percentage of successfull calls by the hour by timezone. Alls well and good.

When I create my report and wizardly drop in the char, Access torments my query to be a crosstab query displaying a sum of percentages. News flash to access, I didn't create my query this way because I wanted it in another way.... (my fustration is growing.)

After trying numerous times, consulting my good buddy google, and searching forums, I need some help. I've noticed that if I go into the properties and change the sql for the control, access then completely disregards my query and fills in its own data that it pulls from thin air. The data it tries to force on me looks like some sales data from different regions or something.

Is there anyway to just graph my data without modifying it? Thanks in advance for help.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[dhookom]

If 2007 is anything like earlier versions... you take your query and use it as the Row Source property of your chart. Take a gander at the datasheet of the Row Source and copy it to the clipboard. Then view the chart design and paste the clipboard into the datasheet of the control. Exit and save it all. Try print preview to see if the chart is as desired.


Duane
Hook'D on Access
MS Access MVP