Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Excel 2003 - Chart Data Label positions

Hi

I have the below chart in Excel 2003:



The data labels are dynamic and link to data which changes each month. I want to be able to set the data labels so that they change position depending on the data displayed.

If the data label is negative, I want to show the label below the bar. If it is positive, I want to show it above the bar. Does anyone know how I can acheive this without manually moving the data labels each month?

Thanks in advance!
  #2   Report Post  
Banned
 
Posts: 3
Default

Quote:
Originally Posted by excellearner View Post
Hi

I have the below chart in Excel 2003:



The data labels are dynamic and link to data which changes each month. I want to be able to set the data labels so that they change position depending on the data displayed.

If the data label is negative, I want to show the label below the bar. If it is positive, I want to show it above the bar. Does anyone know how I can acheive this without manually moving the data labels each month?

Thanks in advance!
You need to add two dummy series (line or better XY scatter) just for the labels.
Use an IF function to only assign values to these series if they are positive / negative.
When done switch labels on and hide the line!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Label Positions Chad Cameron[_2_] Excel Programming 1 February 20th 10 12:24 AM
2003 Excel Radar Chart Data Label Position Bill Excel Discussion (Misc queries) 1 September 25th 08 02:48 PM
Can you change the length of an excel chart data label? Alia Charts and Charting in Excel 1 May 16th 06 04:48 PM
Excel 2003 multilevel subtotals in wrong positions JMA7450 Excel Worksheet Functions 0 April 5th 06 10:18 PM
Subtotals in wrong positions excel 2003 Charles Excel Programming 1 March 1st 06 01:11 AM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"