want to prepare chart with 2 values

If you want to show absolute numbers and percentages in the same clustered column chart, you need to move one series, either absolute numbers, or percentages to the secondary axis.

Post a workbook with your data and chart and someone here will be able to help.

Edit: see attached for a suggestion of data layout for a combined column chart

cheers