How can I post values in excel chart without displaying the colum.

[Noa]

I have 3 variables, I would like to display 2 of them as column in a column
chart, and would like the third variable's values to appear on top of the
other columns, without presenting the third variable as a column.

 

[Andy Pope]

Hi,

You could plot it as a line or column and then remove border and fill
formatting.
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

 

[Noa]

Thanks Andy!
Is there a way to post the values on top of the highest column in the chart
(regardless of the hight of the hidden column)? I am using a column chart and
not a stacked chart.

Thanks,
Noa

 

[Andy Pope]

So you have a cluster column chart with columns side by side. Do you want
the 3 data value displayed above the taller of each pair of columns?

Cheers
Andy

 

[Noa]

Yes, I need the 3rd value dispalayed above the taller of each pair of columns.

 

[Andy Pope]

Hi,

You need 2 dummy series with data based on Col1 and Col2 data. This will
have their data labels linked to 2 more columns of cells with text based on
column 3

Assume this is the data

A1: =<empty> B1: =Col1 C1: =Col2 D1: =Col3 E1: =DumCol1 F1:
=DumCol2 G1: =DumCol1Lab H1: =DumCol2Lab
A2: =a B2: =1 C2: =2 D2: =10 E2: =IF(B2>C2,B2,NA()) F2:
=IF(B2<=C2,C2,NA()) G2: =IF(ISNA(E2),"",$D2)
A3: = b B3: =2 C3: =3 D3: =20
A4: = c B4: =3 C4: =2 D4: =30
A5: =d B5: =4 C5: =3 D5:= 40

Cells E2:G5 can be filled by dragging formula down.
Cells H2:H5 can be filled by dragging G2:G5 right.

Now create a cluster column chart on A1:F5 plotting data in columns.
Delete Data3 series
Move DummyCol1 and DummyCol2 to secondary axis
Delete secondary axis
Link DummyCol1 data labels to the range G2:G5 position outside end
Link DummyCol2 data labels to the range H2:H5 position outside end

You may need to adjust the formula in the event of ties. Currently the
information is displayed on the right side is a draw.

This addin will allow you to easily link data labels to cells.

Cheers
Andy
http://www.appspro.com/Utilities/ChartLabeler.htm