Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
Quote:
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Label Positions | Excel Programming | |||
2003 Excel Radar Chart Data Label Position | Excel Discussion (Misc queries) | |||
Can you change the length of an excel chart data label? | Charts and Charting in Excel | |||
Excel 2003 multilevel subtotals in wrong positions | Excel Worksheet Functions | |||
Subtotals in wrong positions excel 2003 | Excel Programming |