How to change tick mark lables in z axis from values to texts?

[Guest]

I am drawing a column chart for the dynamic scales in a music piece. Data
value I key-in the spreedsheet refers to other customary names (texts). For
example, 7 represents ff (fortissimo), 6 represents f (forte), 5 for mf
(mezzo forte), 4 for mp (mezzo piano), etc. I want to show these customary
names instead of showing values in the z axis. Could anybody teach me how to
change these tick mark lables in z axis from values to texts?

 

[Suzanne S. Barnhill]

You can add them manually using text boxes (omit the default scale labels).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Suzanne S. Barnhill]

You can add them manually using text boxes (omit the default scale labels).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Rmxyb2E=?=,

I am drawing a column chart for the dynamic scales in a music piece. Data
value I key-in the spreedsheet refers to other customary names (texts). For
example, 7 represents ff (fortissimo), 6 represents f (forte), 5 for mf
(mezzo forte), 4 for mp (mezzo piano), etc. I want to show these customary
names instead of showing values in the z axis. Could anybody teach me how to
change these tick mark lables in z axis from values to texts?

You've asked this in a WORD forum, by mistake. I think you'll need to ask in an
Excel charting forum, instead

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Rmxyb2E=?=,

I am drawing a column chart for the dynamic scales in a music piece. Data
value I key-in the spreedsheet refers to other customary names (texts). For
example, 7 represents ff (fortissimo), 6 represents f (forte), 5 for mf
(mezzo forte), 4 for mp (mezzo piano), etc. I want to show these customary
names instead of showing values in the z axis. Could anybody teach me how to
change these tick mark lables in z axis from values to texts?

You've asked this in a WORD forum, by mistake. I think you'll need to ask in an
Excel charting forum, instead

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Suzanne S. Barnhill]

I assumed the OP was using Microsoft Graph in Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Suzanne S. Barnhill]

I assumed the OP was using Microsoft Graph in Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.