Results 1 to 2 of 2
Thread: Bargraph Report (Office XP)
2002-06-03, 05:48 #1
- Join Date
- Feb 2001
- New Zealand
- Thanked 0 Times in 0 Posts
Bargraph Report (Office XP)
I have two problems with a bar graph report. The bar graph is based on a parameter query that lists both the number and type of client contacts between two dates. The dates are requested when the report opens. I used between [enter the first date] and [enter the second date] as the criteria in the query that the report is based upon.
The bar graph opens OK and I can view it, however, when I attempt to print it, the query seems to run again i.e it prompts for the dates again.
I use this approach for a lot of other reports and it works fine.
Secondly, the bar graph lists the client contact type on the x axis with a count at the top of the bar. On top of the bar is the actual number e.g. 9, but there is only a tiny gap between the top of the bar and the number. In some circumstances, this makes the actual number very hard to read.
While you can get a general idea of the number from the y axis, there is a need to be able to view the number clearly.
2002-06-03, 07:05 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Bargraph Report (Office XP)
I have no ideas about the first question.
About the second question:
You can experiment with the placement of the data labels. Double click the chart (in design view of the report), then double click the data labels; in the last tab you can set the label position.
As an alternative, you can show the data table instead of data labels. You can set this by (double clicking the chart and) selecting Chart/Chart Options, Data Table tab.