Regarding the question, that how to rotate the x-axis labels, just go the properties of the chart and look for "Category axis Tick Label rotation" here you can fill any desired angle, you want to rotate your labels (ex. 90) it will rotate the horizontal labels to vertical...try this...