View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Get data labels off of my data series!

You could add a line chart series to the chart, using Y values that put the
points where you think the labels should be positioned. Format the line
series to have no markers or lines, and affix the labels to this series.

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


"Mike" wrote in message
...
I have a clustered column chart with 2 data series. Data labels are
formulas
which pull values from another sheet (used to show the delta between the 2
data series). For some reason, they like to sit right on top of one of
the
data series, and each time the chart is updated I have to move the labels
up.
This is extremely annoying and I'd like the labels to get the heck out of
the way without my manual intervention. I tried changing the label
position
under Label Options, and I also tried changing the vertical alignment
under
Alignment, Text Layout - both to no avail.

Help!