AOB
Registered User.
- Local time
- Today, 00:20
- Joined
- Sep 26, 2012
- Messages
- 637
Hi there,
I have a form with a chart object (among other controls)
The chart shows a simple line graph with dates along the x-axis.
The chart data is driven by a simple TOP 10 / ORDER BY DESC query (so the chart should only plot the last 10 available days of data as tables are updated)
The problem is, the chart is including the weekend dates on the x-axis as well, even though these dates are not present in the table which is being queried.
How do I remove these dates from the x-axis of the chart as they are misleading. In Excel I would just designate the x-axis category to be text rather than date and it would only plot the dates available rather than filling in the blanks in between. But in Access I don't seem to have this option?
Thanks
AOB
I have a form with a chart object (among other controls)
The chart shows a simple line graph with dates along the x-axis.
The chart data is driven by a simple TOP 10 / ORDER BY DESC query (so the chart should only plot the last 10 available days of data as tables are updated)
The problem is, the chart is including the weekend dates on the x-axis as well, even though these dates are not present in the table which is being queried.
How do I remove these dates from the x-axis of the chart as they are misleading. In Excel I would just designate the x-axis category to be text rather than date and it would only plot the dates available rather than filling in the blanks in between. But in Access I don't seem to have this option?
Thanks
AOB
