On Thu, 22 Mar 2007, in microsoft.public.excel.charting,
FGM < XXXX@XXXXX.COM > said:
You can format numbers in different colors, by using custom number
formats and making sure that the axis format "Linked to source" box is
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:
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.
NB Personal replies to this post will send email to XXXX@XXXXX.COM ,
which goes to a spam folder-- please send your email to del3 instead.