Creating charts or graphs from your data in Google Sheets provides you with an effective way to display information to your audience. The actual process of creating that chart can be quite simple, so once you have added all of your data to your spreadsheet, you don’t need to fret about a complicated additional task. […]

Google Sheets is a great alternative to Microsoft Excel, and provides you with many of the tools that make Excel such an appealing application. One of these tools allows you to create a graph or chart to provide a visual representation of your data. But you may find that the chart or graph you create […]

When you create a new workbook file in Google Sheets it will have one worksheet tab by default. In many cases this is going to be fine, but some spreadsheet needs will dictate that you add more worksheets to that file. This is something that you can do in Google Sheets, and there are several […]

Date formatting has long been an issue for spreadsheet users. Sometimes a spreadsheet won’t recognize an input as a date and assign it a weird number, while other times it will put the date into a format that is different than what you want to use. Fortunately you do have some control over how your […]

When you type a lot of data into a cell in your Google Sheets spreadsheet, one of several things can happen. The text can overflow into the next cell if it’s empty, it can be forced to another line within the cell, or it can be clipped so that only the text that fits in […]

When you are creating a spreadsheet that is going to be shared with other people, it’s common to have a particular column of data that is more important than others. But if there is a sufficient amount of information in your spreadsheet, you might be concerned that the importance of that data might get lost […]

When you make a change in one of your Google Sheets spreadsheets, certain functions will recalculate so that you always have the most current information. These functions include NOW, TODAY, RAND and RANDBETWEEN. But your needs might require these items to recalculate more frequently than that, such as every hour, regardless of changes, or even […]

Making documents publicly accessible from your Google Account is one of the simplest ways to let other people view your work. There are a couple of different ways that you can accomplish this, including an option to simply publish the document and generate a link that you can send to people. If the document that […]

Occasionally when you have a cell or range of cells in a spreadsheet it contains data or a formula that can never change. As the creator of that spreadsheet you will likely remember that you shouldn’t edit anything in those cells, but spreadsheets that are sent to or shared with others are often edited in […]

Sometimes the data that you are creating in a spreadsheet is better understood if you can create a visual representation of that data. This is often best achieved by making a graph so, if you are working on a spreadsheet, you may find yourself wondering how to make a graph in Google Sheets. Fortunately this […]