change color of x-axis individual points

[jennxf]

[TABLE="width: 500"]
<tbody>[TR]
[TD]a
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]c
[/TD]
[TD]6
[/TD]
[/TR]
</tbody>[/TABLE]

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!