Trending Data on Line Chart

[Processor]

Okay. So i made my DB the newer version and tried again. It seems to work and display the X axis labels when there are not too many. When i increase the plotted data points to the point where they will basically become unreadable, they disappear altogether. Now, i just have to figure out how to control the frequency of the labeling.

[June7]

In my testing, the labels did not disapper completely, just did not display all. Interesting.

Glad you have some progress.

Report in Design, double click graph or right click > Chart Object > Edit to enter chart editor. Then double click on X axis or right click over the axis line > Format Axis and set parameters on Scale tab.

[Processor]

Okay. Never mind. Somehow, i got it working as i thought it should. Autonomously. The only thing i can put my finger on that might have help was removing the day, month, and year formatting from the script.

Thanks again for all your help!

[Processor]

Hmm. Just saw this. That will be helpful i'm sure. I'll check it out.

[Processor]

I have a new issue today.... For some reason, occasionally when i produce this report, i get the below graph...

Notice that it has placed the first half of the data at the end and the last half at the beginning. I'm not sure why it does this as the records in the table are in order when i review them. This happens about half the time the report is ran. Any ideas?

[isladogs]

Not sure what your chart SQL is but suggest you add an ORDER BY clause to sort the x axis as you would expect