Charting Problem with x-axis
The X-axis displays each data point. The problem is that there are so many data points for any time period that the numbers print on top of each other so that you can't read any of the numbers on the x-axis. Instead of printing each data point on the x-axis, I would like to identify just the major numbers on the x-axis like I can do with the y-axis. For example, I have 400 data points for a four-hour period from 5:00 to 10:00. I want the x-axis to show just 5:00, 6:00, 7:00, 8:00, 9:00 and 10:00 and not each individual point-in-time. Is this possible?
You can use a calculation for the x axis that returns null for all but major values such as:
If ( Hour ( timeField ) = timeField / 3600 ; TimeField ) // 3600 seconds = 1 hour