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

N

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.
 
N

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
 
A

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Scatter PLotting using Data in third colum to determine range 2
Sort a data without affecting the scatter chart 1
How do I Add a variable in the legend without charting the data? 1
How do I combine stacked and clustered chart types? 2
Trying to total the column values in my chart? 3
Changing Values in Chart Series 2
How can i create a 2-D stacked column within a 4 series stock char 6

Top