In the sample database I have Sample Report which is the graph I want to modify, the graph data is a crosstab query based on the Sample Query.
What I would like to do is add a horizontal line in the graph to plot the flat Facility Avg Index, on the line I want to have the text “Facility Average 2.02, Total Equipment Count 253”, and the Facility Average and Total Equipment Counts should not appear in the chart legend. I’d also like to allow the Y axis scale to auto scale the max value based on the Area Avg Index, currently it scales on the largest value of Area EQ Count, but these values I only want to show in the legend not in the actual graph. What I did to hide the column in the chart was to set its board and back color to white.
I’ve read a few tricks to do these things in excel but I need to do them in Access 2007. Any help is appreciated.
Thanks in advance,