1 Reply Latest reply on Oct 15, 2012 1:59 PM by Tracy Rodgers

    Add Year Dividers to Axis with Continuous Date

    Aaron Rubinstein

      I have a question about formatting dates on a chart axis. In the attached workbook, Sheet 1 is basically what I am going for, except that I do not want to show every individual date on the x axis; I would prefer to only have one tick mark for each month. I was able to accomplish this in Sheet 2 by switching the date dimension to "Continuous" and then formatting the axis labels. The issue is that I would still like the line chart to be broken up by year, as it is on Sheet 1. I tried adding Year as a discrete dimension on the Columns shelf but that did not work as desired.

       

      Any suggestions would be appreciated.