- Joined
- Feb 3, 2006
- Messages
- 1
- Reaction score
- 0
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!
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!