Format Individual Axis Labels

Format Individual Axis Labels

Post by Del Cotte » Sat, 24 Mar 2007 05:48:05


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
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.

--
Del Cotter
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.
 
 
 

Format Individual Axis Labels

Post by RkdN » Sat, 24 Mar 2007 20:32:08

Did not understand the dummy series.... can you tell me more?
thanks for all your help..

 
 
 

Format Individual Axis Labels

Post by Del Cotte » Sun, 25 Mar 2007 10:40:20

On Fri, 23 Mar 2007, in microsoft.public.excel.charting,
FGM < XXXX@XXXXX.COM > said:

http://www.yqcomputer.com/

http://www.yqcomputer.com/

--
Del Cotter
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.