'Outside End' label problem

[Guest]

Win XP
Office 2003 Pro SP2

All,
I have a group of bar charts that display pecent information for our
products (growth, share change,...). Each chart has a single series that
displays one of these metrics. Each series uses the 'outside end' option for
the labels and the x (Category) axis crosses at the 0 (zero) value.

The problem is that randomly some of the negative labels will display
above the axis as if positive, even if there is room to display below the
line. Is there a way to correct this issue.

Thanks!

 

[Brian Reilly, MVP]

Simply select the single data point by double clicking it. You will
then be able to drag just that data point to whereever you want it.

Brian Reilly, MVP

 

[Guest]

Brian,

Thank you for your rely. I was hoping for something else. The process that
builds this presentation has been completely automatated from ETL to
distribution. I was hoping for a chart setting.

 

[Brian Reilly, MVP]

Welll if you are already coding you could do some testing and see what
conditions make the label go the wrong way and set up a select case
statement to check for the values in each datapoint and move the .top
of the datapoint label to where you want it. If you are an experienced
coder it should probably take you about a hour to set up your
conditions and 15 minutes to write the code.

Brian Reilly, MVP