Chart Axis Formatting

[EasterGreen]

I have the following data:

5/22/14	100
5/31/14	105
6/30/14	110
7/31/14	120

<colgroup><col><col></colgroup><tbody>
</tbody>

But want the axis to show:

5/22/14	100
5/14	105
6/14	110
7/14	120

<colgroup><col><col></colgroup><tbody>
</tbody>

That is, no "days" except for the first data point.
I have formatted the labels correctly in the data table but cannot get this to push into the chart.

 

[Worf]

Hi

Take a look at the page below, which shows how to use data labels as axis labels. Note that a data label can be individually formatted.

Custom Axis Labels and Gridlines in an Excel Chart - Peltier Tech Blog