If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'Outside End' label problem
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! |
#2
|
|||
|
|||
'Outside End' label problem
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 On Fri, 28 Sep 2007 05:35:01 -0700, T-Casey wrote: 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! |
#3
|
|||
|
|||
'Outside End' label problem
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. -- Tom Casey Project Supervisor sanofi-aventis "Brian Reilly, MVP" wrote: 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 On Fri, 28 Sep 2007 05:35:01 -0700, T-Casey wrote: 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! |
#4
|
|||
|
|||
'Outside End' label problem
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 On Fri, 28 Sep 2007 10:15:02 -0700, T-Casey wrote: 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. |
Thread Tools | |
Display Modes | |
|
|