cluster column chart with data point labels
 

I'm trying to create a cluster column that has a label above each data
point.

The columns are the total number of an event that happened and then I
need a label that shows what % of a goal those number of events
represent. There is no relationship between the data and the % label.

Jan (cluster 1)
A: 34 label: 98%
B: 52 label: 102%
C: 23 label: 96%

Feb (cluster 2)
A: 36 label: 102%
B: 56 label 110%
C: 21 label 92%

Can someone help me design this chart?

Thanks.

John

cluster column chart with data point labels
 

Try one of these utilities which add labels from a worksheet range to a data
series. Both are free, easy to install, and easy to use.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"robotman" wrote in message
ups.com...
I'm trying to create a cluster column that has a label above each data
point.

The columns are the total number of an event that happened and then I
need a label that shows what % of a goal those number of events
represent. There is no relationship between the data and the % label.

Jan (cluster 1)
A: 34 label: 98%
B: 52 label: 102%
C: 23 label: 96%

Feb (cluster 2)
A: 36 label: 102%
B: 56 label 110%
C: 21 label 92%

Can someone help me design this chart?

Thanks.

John

cluster column chart with data point labels
 

Thanks, Jon.

I was trying some way to do it by creating another "label" series and
setting the line and marker colors to none with the "label" series. I
wasn't having much luck getting things to line up, though.

The utilities are great for now. Thanks!