1 of 1 people found this helpful
I think your problems lies with the fact that the Year is formatted as a String. If you are able to convert it to Date or Number, then do that, and make it Continuous. Then, right click on the axis, Edit Axis, and you can adjust the axis to start with 2009.
I hope this helps!
Hi Walt Reed,
Thanks for the suggestion! When I made the axis continuous, all of the year values from 2006-2016 returned. At first, I hid the header and added two reference lines (constants) for 2006 and 2016. Then, I formatted them to look like they were on the axis. That was a huge workaround and I was about to reply to see what else could be done before I realized a better solution. I set the tick marks to fixed every 10 years, starting with 2006.
This made it so only the 2006 and 2016 values showed up and didn't require the messy reference lines. That is probably an obvious solution for most people, but wanted to include it in case anyone else had the same issue.