I am trying to do a graph in Excel 2013 that uses custom dates that skips weekends along the Y axis. What I am currently using is =C26+IF(WEEKDAY(C26)=6,3,1) where C26 is the previous date and I have a list of ten dates using this. The only way that I have currently found to attach these dates to the Y axis is to use text boxes and then set the text boxes to the text fields with my dates. However this option makes it harder to update the graph with either more or less dates and it does not look very good.
Is there a way to set the Y axis to these custom dates?
Is there a way to set the Y axis to these custom dates?
