Align Line Chart's data series Data labels on top of Bar chart data series

Hi Everybody,

this is my first post in the forum. So far I've been browsing through archives and I found really helpful and interesting material as well.
I'll try to explain my issue as clear as possible.

I have a chart with primary and secondary axis. I've plotted 2 series (bar chart) on primary and one series on secondary (line chart). The chart feeds from a table which generates values based on some formulas. The line chart series is in percentages hence why it's plotted against a seperate axis. Now the percentages can either be positive or negative. It's pretty much random and it represents change percentages. Whenever the table is populated these percentages change. Subsequently the data labels change places on chart area making them quite difficult to read (some even extend below the x axis).

I would like to know whether there's any code to place the line's chart data series data labels, where the bar chart data series would normally be- proferably on top of the bar (I am not using any data labels for the bar chart data series).

Any help would be highly appreciated.

Thanks,
Andreas

Hi Andy,

thx for this. I can see how it will work. However since I am doing this on a company pc I'm afraid I cannot install any third party programs this means that I cannot install add-in. I had a look in the excel spreadsheet you've attached and this is exactly what I want. Is there any other way to acomplish this?

By the way, how does this thing work since I don't have the appropriate add-in?

Thanks for all the help,
Andreas

Andy,

that's great indeed! I solved it! Thanks mate.

By the way I've just bookmarked your site! I reckon there's great stuff in there!

Cheers,
Andreas