Search code examples
excelchartsexcel-formulaexcel-2007vba

Excel : Horizontal axis label changed when making a chart

I was making a chart (stacked column) based on data in excel in which the horizontal axis labels relate to this row : 

1-Feb  2-Feb  3-Feb  6-Feb  7-Feb  8-Feb

However, in the chart, all has changed to : d-Feb.

I tried all the options but I cannot change it back.

If you had a solution using VBA it would be great too.

The stacked column chart is like this but bigger :

For the y axis, stats are : 

647  810    1001 719  
300  720    420  360  
330  210    390  250  
0     60     60  108  
270  240    270  300  
0     60      0   60  
285  270    180  270  
510  460    375  330

For the x axis, labels are (no weekend days) : 

1-Feb   2-Feb   3-Feb   6-Feb

Thank you in advance.

Solution

  • I found the solution. In the chart axis option, choose date as format, then enter *jj/mmm and click add. It has to have *, otherwise it wouldn't work.