data label bug?

[Jill]

I created a conditional chart which shows two different types of columns... one column type shows actual # days to sign a contract, and the other shows contracts that are still pending and # days it's taken so far. they are set up conditionally so that they only display one type of column per contract

i changed the max y axis value to 30 (with the maximum actual value being 60). this causes a few of the columns to be cut off. i've turned off data labels for one of the column types, and i'd like the data labels for the other to be on the inside edge.

the problem is that the data labels of the columns that are cut off aren't showing. i find the "hidden" text boxes and manually move them, but the text doesn't show. i've tried changing the font, size, and color, to no avail. i can't get them to show up, even if i place them outside of the column. this only happens with the "inside edge" option for label placement

anyone heard of this

thanks

jill

 

[Jon Peltier]

Jill -

Excel XP or 2003, right? In prior versions the labels would show if the
point they represented fell outside the plotting rectangle but still
within the entire chart area. By "fixing" this in XP, Microsoft hosed a
number of my funky chart types and workarounds.

As a workaround, you could add a Line chart series (add a series,
convert it only to a line type from Type on the chart menu) that has Y
values corresponding to where you want the labels, and labels drawn from
a worksheet range using one of these addins:

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

Both are free, easy to use, and very helpful.

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