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/
_______
Jill wrote:
> 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.
>
Similar Threads
