Hi there!
I have 35 years of daily data and need to present 3 graphs for each year. An example (of 1979) is displayed below. My issue is that for the x axis labels, it's required that the labels sit between the gridlines. I don't know how to adjust it in Excel. From searching what's already out there, it seems people just edit the axis label to fit, but I was hoping for a less manually intensive job for the 105 graphs I have to edit. Also, the end idea is to have all 3 graphs per year in one A3 doc, so they can be read vertically with the date lies matching up between graphs. Therefore, I was hoping that the solution would be linked to the data, so that when they're moved, they don't lose the precise positioning.
Does anyone know the best way to apply this change?
Thanks!
I have 35 years of daily data and need to present 3 graphs for each year. An example (of 1979) is displayed below. My issue is that for the x axis labels, it's required that the labels sit between the gridlines. I don't know how to adjust it in Excel. From searching what's already out there, it seems people just edit the axis label to fit, but I was hoping for a less manually intensive job for the 105 graphs I have to edit. Also, the end idea is to have all 3 graphs per year in one A3 doc, so they can be read vertically with the date lies matching up between graphs. Therefore, I was hoping that the solution would be linked to the data, so that when they're moved, they don't lose the precise positioning.
Does anyone know the best way to apply this change?
Thanks!