Unfortunately I can not use excel charts as I had planned to in my invoice design, so am having to create a basic bar chart through business graphics with in design.

have got the bar chart working but can not get the y axis to be dynamic i.e. based on the min and max values in the columns.

Undoubtedly I will need to use PPT but have no idea how.
Please help.

Cheers