I have a query that returns a count and a day. I am plotting the count on the y-axis and want to show the day on the x-axis. I want the label for the day to appear every 7 days or so so the labels do not overlap.
I have tried every combination of ticks, labels per tick, and column mappings and can't seem to accomplish this.
I get the tick marks every 7 days but, I get every label for every day all bunched up at the bottom of the x-axis.
I know this is an junior level question but I am really stuck.
Thanks in advance.