Graph Frustration

[libraccess]

Attached is a zipped DB of a chart I have been wasting my time on


I thought I had it 1st off See Report1 the second chart looks OK except for the legend order but the chart does not work

The first chart just does not work at all and yet the query is returning the results exactly how I want

data is between 1/1/2012 and 30/4/2012 for the frmReports

any help gratefully accepted

[ssanfu]

Don't know if this will work for what you want, but try changing the code for the open report button to:

Private Sub Command16_Click()
DoCmd.OpenReport "Report1", acViewReport
End Sub

[libraccess]

it is the chart that is not working that is the problem although the acViewReport does bring up the report the graphs still do not respond.
I have had this problem before with this type of chart and have found that they will work if the data source is a table not a query, but of course my data source comes from two tables and MS Chart will only allow one table or one query as a source

[libraccess]

I've sort of found a work around. Run a query append to a tblTEMP chart runs OK. - Compact on close.

Still have the issue of sorting the order of the Legend. MS Chart sorts them in Alphabetical Order and I cant seem to change that

Extreme - High - Low - Medium (thats what I want if only I could swap those last two
or
Extreme - High - Intermediate - Moderate (this works, not quite what I want)

Maybe some knows how I could fool MS Chart

[ssanfu]

I came up with the same work around last night, but I used saved (crosstab) queries for the row sources for the two charts. Easier to troubleshoot.

RE: fooling MS Chart.... haven't used it. Sorry..

[libraccess]

Hi Thanks , I redid this with a crosstab query and must have previously been doing something wrong , so thats all good now, and the other
1:Low
2:Medium
3:High
4:Extreme

does the trick

Thanks again