How do you change x-axis labels in excel? -


Right now, for my conspiracy the X-axis label is: 0,2,4,6,8,10

I want to change it for years: 2013, 2014, 2015, etc ...

How do I do this?

I'm assuming a lot here, but you should specify the category name for the axis. For example:

  ActiveSheet.ChartObjects (1) .Cart.Axes (xlCategory, xlPrimary). CategoryName = Category ("A2: A25")    

Comments