Chart not working

[Drew]

I'm having a hard time getting my access chart to display correctly.



The query table information is simple with just 4 fields...Employee name, Open requests, closed requests, total requests

All I want to do is have a bar chart displayed with, employee names as the "x" axis and the "y" axis some number a little higher then the larget number in the total requests field.

I was able to do this in the past very easily with excel (see photo below), but for what ever reason I just can't seem to get it to work properally in access

http://imagelink.org/image/8700.jpg

Any help would be great thanks

[ajetrumpet]

post what the chart in Access looks like right now. as far as setting the y axis sequence, access does it automatically for you, but it can be changed in chart view manually. By default it's automatically set.

What exactly is going wrong? It's also good to know that MS graph is horrible (if you haven't figured that out by now). I've never been a fan of it. The one thing that erks me is that pre-set graph that always shows up in design view of the form or report, regardless of how the chart actually looks in reality. I have a block of code to fix that, but it only works depending on the OS you have.

[Drew]

This is what my chart currently looks like


http://imagelink.org/image/8701.jpg

Really I guess my only problem is adding new series ("open" and "closed") to the chart so it's linked to the table. Again this seems like such a simple thing to do yet it astounds me that it's proving to be this difficult.

[ajetrumpet]

have a look at this: http://www.databasejournal.com/featu...7-Database.htm

That may help in some regard. it's a pretty darn good article about general chart drafting.

What query are you using for the chart? Notice that in chart view, the dataset is also viewable and it's always a crosstab query. I don't know this for sure, but I think Access can only list one series of data (e.g.-the first column of the records) on the y axis. The plot area data is different though, otherwise the multiple bar chart option wouldn't exist in the wizard.

I would try creating your own crosstab query with the crosstab wizard and put the "Open" "closed" and "total" data across the top and the person's names in the records. So, transform the data series on those fields.

Also, What does your table look like? Depending on it's layout, you might want to do a crosstab with the "open", etc... columns listed down as records. I can guarantee you that if you do it that way, the chart will comply (you may have to adjust the inputs though).