Issues with Charts / Graphs

[AnitaPita]

Hi!

I am trying to do what seems to be simple: I have a report showing on time delivery % by month and year for customers...I simply want to display a bar graph showing the month&year and %. (the query already has a calculated field with the %) But this seems to be such a challenge.. (I have Access 2007) I tried the chart wizard and cannot even preview my data...I know it will show the sample data (with north/east/west) until I run the report but even then it doesn't display my data, just the generic Access sample data. Then I tried to create a pivot chart in a form to embed into the report....can get the month/yr to appear on the bottom but it will not change the bar graphs according to %. Lastly I found a trick online where you can load some code into the on format event procedure which would be perfect but I cannot get that code to work either.
So frustrated, I have spent hours trying to figure out something so simple :/ I would greatly appreciate any assistance/input!

Thanks!!

 

[rammudali]

hi,

why dont you send db with specimen date for analysis and rectification. normaly there should not be any prob or data selection may a problem. pls verify.

 

[here4real]

I am having this exact same issue... Did you ever get a resolution???

 

[AnitaPita]

I able to get it to work but I did it in Access 2010. Pretty sure that was some kind of bug in 2007 or I was missing a patch/update for 2007. Ahh the joys of Access!!!