Move position of data labels on secondary axis

datadrvn

Board Regular
Joined
Apr 7, 2005
Messages
86
I have a bar-chart that represents hours by month for a 12 month period. On a secondary axis, I display an FTE count to represent the number of full-time-equivalent people those hours represent. For example, the month of January has 878 hours, which equates to 4.9 people (equivalent) assuming a person works 180h per month. I then display the data labels but not the bars (no-fill no-border).

The problem is that even though the data labels are positioned above the FTE bar (even though the bar itself is invisible), in come cases, that number is still lower than the top of the hours bar, i.e., the FTE number appears within the colored hours bar.

I'm trying to find a way to offset the labels so they always appear above the hours bar for a given month. I'd rather not have to manually adjust the individual labels each time the charts are updated.

I wish I knew how to post a picture of the chart...never been able to figure that out.

Anyone have ideas? Thanks...Wayne
 

Forum statistics

Threads
1,082,610
Messages
5,366,598
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top