Adjusting the Y axis

Hi Elizabeth, thanks for your query. If your chart is dynamically linked to your data, the scaling on the Y axis should automatically update to fit the largest data value. If it is not doing that, something is going on with the source data, possibly the cell formatting. Check that the cells are all formatting as numbers or currencies etc rather than text or general as this could affect what happens on the chart. Also try cutting and pasting the data onto a new spreadsheet and recreating the chart.

Hope this helps,

Anthony