I am working in Apache OpenOffice Calc (spreadsheet). To rotate a chart, I do this:
Select the chart
Select "FORMAT" from the top menu bar
Select "Graphic" from the drop-down menu
Select "Position-Size" from the available options
Select the "Rotation" tab from the Position-Size pop-up
Go To "Rotation Angle on the bottom of the pop-up
Set the Rotation Angle I want for my chart.
I hope This helps!