Data Labels In Chart

alan_a · Apr 15th, 2002, 02:02 PM

I am a relatively inexperienced user of Excel 97. I have created a simple pie chart and would like to have the data labels appear as both a value and a percentage. Data label options only lets me choose one or the other, but not both. Any ideas? Thanks in advance for your help.

Big Blue · Apr 15th, 2002, 03:11 PM

on step 3 of the wizard, are you not offered 'select labels and percent'?
- if not you may want to make sure you ahve all your addins added to your excel ( check tools/addins...)

-if you're having trouble getting values and percent instead of labels and percent, in step 2 of wizard,in series tab, enter the cell range which has your values in both the values and categories boxes.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 02:02 PM	#1
alan_a New Member Join Date: Apr 2002 Location: Alan A. Posts: 1	I am a relatively inexperienced user of Excel 97. I have created a simple pie chart and would like to have the data labels appear as both a value and a percentage. Data label options only lets me choose one or the other, but not both. Any ideas? Thanks in advance for your help.

Apr 15th, 2002, 03:11 PM	#2
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	on step 3 of the wizard, are you not offered 'select labels and percent'? - if not you may want to make sure you ahve all your addins added to your excel ( check tools/addins...) -if you're having trouble getting values and percent instead of labels and percent, in step 2 of wizard,in series tab, enter the cell range which has your values in both the values and categories boxes.