Data labels on graphs

Helen · Apr 18th, 2002, 06:01 AM

I have created some graphs, and I want to add % data labels to each bar. The %s aren't included in the source data, as I want to show the % separately - but all I can see is how to do data labels for the data selected.

Is there any way around this? I hae tried text boxes but Excel is funny and they disappear sometimes!

shades · Apr 18th, 2002, 07:37 AM

Regarding the "disappearance" of the text box. All objects are layered in Excel. If you create the graph first, then the text box, the text box will be on top of the graph. However, if after creating the text box, you re-select the graph, that action temporarily brings the graph to the front. Click outside the graph into a cell. That should then put the graph and text box back into correct sequence.

If that doesn't work, then if you don't have the drawing toolbar visible, go to VIEWS > TOOLBAR > DRAWING. It should appear in the lower left hand corner.

Then select the graph, go to DRAW > ORDER > SEND TO BACK. Click outside the graph. Now the graph will be the farthest back object. And the text box will appear in front.

Big Blue · Apr 18th, 2002, 07:49 AM

% and label ooption is onlt available for pies and doughnuts,

BUT

if you add a column which calculates percentages and include it in chart data, in step 3 of wizard you can go to DATA TABLE tab, and click to include a Data Table.

Result:

you can have value label at end of bars, and a chart of related percentages under (or next to) the bar chart.

Let me know if any clarification needed.

Apr 18th, 2002, 07:37 AM	#2
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	Regarding the "disappearance" of the text box. All objects are layered in Excel. If you create the graph first, then the text box, the text box will be on top of the graph. However, if after creating the text box, you re-select the graph, that action temporarily brings the graph to the front. Click outside the graph into a cell. That should then put the graph and text box back into correct sequence. If that doesn't work, then if you don't have the drawing toolbar visible, go to VIEWS > TOOLBAR > DRAWING. It should appear in the lower left hand corner. Then select the graph, go to DRAW > ORDER > SEND TO BACK. Click outside the graph. Now the graph will be the farthest back object. And the text box will appear in front. __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

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

Apr 18th, 2002, 06:01 AM	#1
Helen Board Regular Join Date: Feb 2002 Posts: 103	I have created some graphs, and I want to add % data labels to each bar. The %s aren't included in the source data, as I want to show the % separately - but all I can see is how to do data labels for the data selected. Is there any way around this? I hae tried text boxes but Excel is funny and they disappear sometimes!

Apr 18th, 2002, 07:49 AM	#3
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	% and label ooption is onlt available for pies and doughnuts, BUT if you add a column which calculates percentages and include it in chart data, in step 3 of wizard you can go to DATA TABLE tab, and click to include a Data Table. Result: you can have value label at end of bars, and a chart of related percentages under (or next to) the bar chart. Let me know if any clarification needed.