Windows 2000 Excel 2002
Two questions:
is there a way in visual basic or manually to format grid lines individually
....

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.

Thanks for any help.

No but you can add horz. and vertical lines.
See http://peltiertech.com/Excel/Charts/...orzSeries.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"FGM" wrote in message
...
Windows 2000 Excel 2002
Two questions:
is there a way in visual basic or manually to format grid lines
individually
...

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.

Thanks for any help.

On Thu, 22 Mar 2007, in microsoft.public.excel.charting,
FGM said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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

"Del Cotter" wrote:

On Thu, 22 Mar 2007, in microsoft.public.excel.charting,
FGM said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

On Fri, 23 Mar 2007, in microsoft.public.excel.charting,
FGM said:
Did not understand the dummy series.... can you tell me more?
thanks for all your help..

http://www.tushar-mehta.com/excel/ne...ble_log_scale/

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.