change color of x-axis individual points

[jennxf]

a	2
b	4
c	6

<tbody>
</tbody>

I want to plot a line chart with the first col being the x axis and the second col being the y axis. However, i also want the color of each point on the axis to be as in the table. How can i change the default which is black? I know we can change the color of the text on the x axis but we must change all to the same color. I am using excel for mac 2013.

Thanks.

 

[Jon Peltier]

You mean you want to change the color of each label on the axis?

This can be done indirectly, by hiding the default labels and adding a hidden series with data labels. These data labels can be individually formatted, which axis labels cannot.

I wrote a tutorial about it here: Individually Formatted Category Axis Labels.

 

[jennxf]

You mean you want to change the color of each label on the axis?

This can be done indirectly, by hiding the default labels and adding a hidden series with data labels. These data labels can be individually formatted, which axis labels cannot.

I wrote a tutorial about it here: Individually Formatted Category Axis Labels.

Really smart!