Marketing Knowledge
      Back to home
      1. Help Center
      2. Marketing Knowledge

      Create a chart in Google Sheets

      How to create a chart in Google Sheets

      Step-by-Step Guide to Creating a Chart in Google Sheets:

      1. Prepare Your Data:
        • Enter your data into Google Sheets. Make sure your data is organized with headers in the first row and relevant information in subsequent rows.
        • Create a table to be used in your chart. The specified data in the chart should be in this table. 
        • For Weekly Graphs: Use Today() to get the current date and just subtract from that date to get the running week dates. Use SUMIF formula to summarize the data from the other tabs. 
        • For Monthly graphs: A new column in every raw tab must be created in order to have a month reference in your chart. Use Text() formula to extract Month from a date value. Reproduce the same calculation in each tab to get the summarized data in your table (ie Buy Rate = Sales/SS Attended). 
      2. Select Data to Chart:
        • Click and drag to select the data range that you want to include in your chart. This range should include both the X-axis (horizontal axis) and Y-axis (vertical axis) data.
      3. Insert a Chart:
        • With your data selected, go to the top menu and click on Insert > Chart. This will open the Chart Editor on the right-hand side of your Google Sheets window.
      4. Choose a Chart Type:
        • In the Chart Editor, you'll see a variety of chart types under the "Chart type" dropdown menu. Select the type of chart that best suits your data (e.g., Column chart, Line chart, Pie chart, etc.).
      5. Customize Your Chart:
        • Once you’ve selected a chart type, you can customize it further using the options in the Chart Editor:
          • Chart & axis titles: Add titles for your chart and axes.
          • Legend: Turn the legend on or off, or position it as needed.
          • Series: Customize each series (data set) by changing the color, adding data labels, or adjusting the series type (e.g., line style for a line chart).
          • Chart style: Choose different styles and color schemes for your chart.
          • Data range: Adjust the data range if you need to include or exclude certain rows or columns.
      6. Save and Insert Your Chart:
        • Once you’re satisfied with your chart, click the "Insert" button in the Chart Editor. This will insert the chart directly into your Google Sheets document.
      7. Edit and Update Your Chart:
        • You can always go back and edit your chart by clicking on it and then clicking the edit icon (pencil icon) that appears in the top right corner of the chart. This will reopen the Chart Editor for further modifications.