Excel 2007 : Numeric and percentage values in a chart

Hi!

Is there a way to get numeric and percentage values aligned like in the attached picture (sample.JPG) ?

I followed instructions from

http://excelribbon.tips.net/Pages/T0...ph_Column.html

and successfully combined the primary and secondary y-axis, but the data labels overlapped each other.

The reason why I need to automatically align them is that I generate .xlsx and .pptx files directly from code for customers and the layout for the bar and column charts should be similar to the one in the attached picture.

The article notes that the other axis' data labels should be centered, as it would prevent overlapping, but due to the layout issue I "can't" center them. :p

Best regards,

Tuomas Hynninen