View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
suejay suejay is offline
external usenet poster
 
Posts: 7
Default Leader Lines - Stacked Column Charts

Hi Andy-
Thanks for your suggestion - yes, we are forced to manually move the data
labels because the charts need to be small enough to fit on a PowerPoint
slide. How would I fake the leader lines with a dummy xy scatter series?
It's worth a try!

"Andy Pope" wrote:

Hi,

Pie charts are the only ones with built-in leader lines.
Stack column charts only have the option of positioning the labels Top,
Middle or bottom of column.

Are you manually moving the data labels?

I guess, as long as the chart is not 3d, you could fake the leader lines
using dummy xy scatter series.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"suejay" wrote in message
...
Help! Is there any way to use automatic leader lines to the data labels
with
stacked column charts???
Thanks!