Waterfall Chart Data Labels

**nickFe** · 02-16-2011, 06:40 AM

Hi All,
I have modified a friend's waterfall chart so that it can basically be used with any data positive or negative.
The main problem im having is data labels - I want them in the middle of the bars.
If I change the data, especially when it crosses the 0 line, my data labels all require manual manipulation.
Can anyone think of a good way to have the data labels centred in the bars?
I have attached a spreadsheet to have a play with.
Many thanks,
Nick

**Andy Pope** · 02-16-2011, 09:10 AM

You can added a series plotted as line which is positioned in the center spot.
If you move to the secondary axis and use another set of category labels you can get the data labels to display the correct value.

BTW I think you need to check the results of your chart.
New Buisness has a value of zero but your chart displays -140.

**nickFe** · 02-16-2011, 10:22 PM

Originally Posted by Andy Pope

You can added a series plotted as line which is positioned in the center spot.
If you move to the secondary axis and use another set of category labels you can get the data labels to display the correct value.

BTW I think you need to check the results of your chart.
New Buisness has a value of zero but your chart displays -140.

Andy Pope, thank you very much for your help, this is great.
Where do you live I want to buy you some beer!