Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart where I want a data point for every day of the year and have all data points be visible without scrolling. I know I'm supposed to check the box for continuous in the Axis tab, but when I do this, the chart shows the label for the first day of each month.
How can I get it to show the label for the last day of the month (while still plotting the points for all days in between)?
That is not what I'm looking for. If you notice in your chart, you're missing all of the data points in between the visible dates. Below is what I'm able to get. Except I want the label to be for the last date of the month, not the first.
May not be the best option, but this is the most I was able to figure out
That wouldn't work at all. It just changes all of the date labels to MM/30. So if I filtered down to a single month, it shows 1/30 1/30 1/30 over and over instead of 1/1 1/2 1/3.
Yup don't know of a way to do this...