x-axis labels -- pass formatting to chart from spreadsheet

[kevin.g.ward]

I am using the x-axis label function while charting data in Excel.

Currently, only the value of the content in each cell selected passes through to the chart.

I would like to learn how to pass the formatting through as well.
The cells are formatted differently from each other (color, font size, bolding)

Formatting the x-axis labels within the chart applies one format to all of them. This is not a solution.

Alternative: Not using the x-axis label option, using the data point label option and then individually formatting them, as well as moving them to the x-axis is time consuming.

Does anyone know how to pass the format of the data in the cell to the text on the x-axis?

Thanx!