Numeric Value and Percentage Value in a graph

[Kmitchell]

Hi There -- looking to create a column chart that would display both the absolute value and the percentage value in a chart. I'm not having any luck -- any suggestions?




Other$ Other % AAM$ AAM%
9/1/2008 3,914,723 46% 4,597,953 54%
9/1/2007 2,184,835 36% 3,966,829 64%
9/1/2006 2,029,604 37% 3,476,841 63%
9/1/2005 2,210,974 38% 3,581,566 62%
9/1/2004 770,035 18% 3,595,985 82%

 

[Mala]

Concatenate (as text) the abs and percent value in cells in a separate column of the data and set the data labels to displlay the values in these cells by putting a formula for each data label.

 

[Kmitchell]

Thanks for the tip. How do I create a formula? When I concatenate it displays the percentage as an absolute value.

 

[Mala]

See the formula in C10.

BoardExamples1.xls
	A	B	C	D
9	Value1	Value2	Concatenated
10	3,914,723	46%	3,914,72346%
Sheet15

 

[Mala]

To create the formula for a data label, select all data labels by clicking any one data label, then select the data label of choice by clicking it. In the formula bar type = and point to the cell (e.g. C10) whose text you wish to appear in the label. Do this for all data labels in turn.