oohmygod831
Registered User.
- Local time
- Today, 20:18
- Joined
- Feb 16, 2005
- Messages
- 43
i have a database that uses queries to create pivot charts to display the data.
The query asks the user to first enter a month and a year as a filter and then displays the chart.
My problem is that because it asks the user for the month and year it doesnt display the data labels on the chart (ie value displayed on end of each bar)
If i use a simple query that doesnt ask for filter data then the data labels are fine and they change when records are added to the tables. But that isnt what i need.
Any Ideas, sorry if im being vague or confusing but im a bit brain fried today.
The query asks the user to first enter a month and a year as a filter and then displays the chart.
My problem is that because it asks the user for the month and year it doesnt display the data labels on the chart (ie value displayed on end of each bar)
If i use a simple query that doesnt ask for filter data then the data labels are fine and they change when records are added to the tables. But that isnt what i need.
Any Ideas, sorry if im being vague or confusing but im a bit brain fried today.