Creating Charts

Cards (8)

  • A sales report is a report that includes details about the sales of a product or service—amounts sold, existing and new accounts, etc.
  • There are a lot of ways to insert an image in Google Sheets. One way is by embedding an image online using its URL.
  • =image("URL") or =image("URL", 1)
    This formula will scale the image to fit inside the selected cell.
  • =image("URL", 2)
    This formula will stretch the image to fit inside the selected cell.
  • =image("URL", 3)
    This formula will insert the image into the cell at its original size.
  • =image("URL", 4, height, width)
    This formula allows you to customize the size of the image by specifying the height and width of the image in pixels.
  • You can add a variety of charts and graphs into a spreadsheet, including line, bar, and map, to visually represent written data (i.e. numbers).
  • The Filter feature in google sheets makes it easier to analyze and view data by temporarily hiding irrelevant data. Disabling this makes all data reappear.