Another way to change the vertical scale is to click on the chart to reveal its eight 'handles'. These are small circles, one at each corner and one in the centre of each side. Click and drag on either the top or bottom centre handle to increase/decrease the chart height.


I also notice that your currency data column doesn't look right? I would expect to see $4500 and not $ 4500 (with large space between the $ and 4). That's why I thought the $ was in a column of its own so how did this large space happen?