Why do we need charts in analysing data ?
In the previous chapter we discussed about formatting data to make it presentable to the user. But irrespective of how well it is presented, a spreadsheet with just a table or column of numbers, falls short in informing the user about the trends that lie behind those numbers. The value of a spreadsheet lies not just in neatly organizing the data, but in how well it helps one in analyzing it and inferring actionable information from it. Charting function in Google Spreadsheets helps one to do just that. With the help of charts one can quickly spot the trends behind the data and take appropriate actions.
Next: Types of Charts – Choose the chart to suit the purpose –>