Can we format X axis labels individually? I have frequency for 25 to 10000
and would like to format some of them in bold but not all.
You can format numbers in different colors, by using custom number
formats and making sure that the axis format "Linked to source" box is
checked.
Annoyingly, I've just noticed it doesn't work for text, only numbers.
Text formatted with [Red]@ or [Red]General is red in the spreadsheet but
stays black in the chart. But numbers formatted with [Red]# or
[Red]General go red in the sheet and in the chart.
If you give the labels that you don't want to be "bold" the format:
[Color16]General
then they will be 50% Gray (in my Excel 97's scheme anyway; I understand
MS juggle the color index numbers around at random from release to
release, because they're just fun guys that way). The labels that you
did not turn gray will look bold by comparison.
The other way to get different formats of axis labels in a scatter chart
is to go the "Dummy series" route and create data series that have
either Category (X) or Values (Y) consisting of all zeroes. Then
display the categories or values as labels and format the actual series
to be invisible, and you will have a set of labels that you can manually
format by clicking on them individually.
