Create a bar chart

You can create a bar chart to show comparisons among categories in your data. You can also customize display settings and save a chart from the Trillion-Row Spreadsheet (TRS) to your computer as a PNG or PDF file.

The first step to creating a chart in the platform is to prepare your data. For this tutorial, this step has already been done so you can focus on creating the chart itself. The sample data provided compares the total sales, cost, and profit for stores in a fictitious retail chain. Use this data to create a bar chart comparing the total profit, sales, and cost of all stores combined for each day in the fiscal month of May. After you have created your chart, you will then change display preferences like colors and labels. A chart created in the 1010data Insights Platform TRS can be downloaded as a PNG or PDF file for a variety of uses. For example, you can share the chart with someone who does not have access to the Insights Platform, or you could use the chart as an image within a report or presentation. This tutorial explains how to download a chart as a PDF file.

To create a bar chart:

  1. From the menu bar, select Tools > Trillion-Row Spreadsheet.
    The Insights Platform displays the TRS window.

  2. Open the Bar Chart Sample Data Quick Query (pub.doc.retail.barchartex).
    TRS displays the Bar Chart Sample Data tabulation.

  3. In the analysis pane, click the Visualize tab.
    TRS displays the Visualize options.

  4. Create a bar chart showing the total sales and profit by day.
    1. In the drop-down list below the Update, Reset, and More Options buttons, select Bar.
    2. From the column list section to the left of the buttons, drag Date into the Labels section.
    3. From the column list section, drag Cost, Sales, and Profit, one at a time and in that order, into the Bars section.
      Note: The order in which the columns are arranged in this section, from top to bottom, determines the order in which the columns appear in the chart, from left to right.
    4. Click Update.
    TRS displays a bar chart of your data.

TRS provides a number of customizable settings that control the way a chart is displayed, including the size of the chart, background color, appearance of the title and the axes, and placement of the legend. You can also add titles and labels.

  1. Add a title to your chart.
    1. Click More Options.
      TRS displays the customization settings.

    2. In the customization settings, click Title.
      TRS displays the Title customization settings.

    3. In the Title text field, enter Cost, Sales, and Profit by Date.
    4. Press Enter.
    TRS adds the title to your chart.

  2. Add a text label to the y-axis.
    1. In the customization settings, click Axes.
      TRS displays the Axes customization settings.

    2. At the top of the Axes section, click the Y-AXIS tab.
    3. In the Y-label field, enter Dollars.
    4. Press Enter.
    TRS adds the new text label to the y-axis of your chart.

You can change the colors of the bars in the chart to suit your tastes. In the example above, it might make more sense to change Sales to blue and Profit to green.

  1. Change the color of the bars in your chart.
    1. In the customization settings, click Data Series.
      TRS displays the Data Series customization settings.

    2. Next to the Colors field, click Add.
      TRS displays the Hexadecimal field and Color Preview box below the Colors field.

    3. Click either the Hexadecimal field or the Color Preview box.
      TRS displays the color palette.

    4. In the Theme Colors section, click the red box () in the top row.
      TRS enters the hexadecimal code for the selected red color in the Colors field and changes all of the bars in the table to that color.
      Note: Since there is only one hexadecimal value entered in the Colors field, all of the bars are set to the same red color.

      To change the bar color for the remaining two columns, repeat the process two more times. Each added color changes the bar color of the next column in the chart. Hexadecimal values in the Colors field, from left to right, change the color of the chart object from right to left.

    5. Next to the Colors field, click Add.
      TRS displays the Hexadecimal field and Color Preview box containing the hexadecimal code and color for the first column.
    6. Click either the Hexadecimal field or the Color Preview box and then click the blue box () in the top row of the color palette.
      TRS adds the hexadecimal code for the selected blue color to the Colors field and changes the Sales bars to blue.
    7. Next to the Colors field, click Add.
      TRS displays the Hexadecimal field and Color Preview box containing the hexadecimal code and color for the second column.
    8. Click either the Hexadecimal field or the Color Preview box and then click the green box () in the top row of the color palette.
      TRS adds the hexadecimal code for the selected green color to the Colors field and changes the Profit bars to green.

Finally, download your chart as a PDF file.

  1. Right-click anywhere on the chart and select Download As > PDF from the menu.
    TRS saves the chart to your computer as download.pdf.
    Note: Depending on the browser you are using, you may be prompted to open or save the PDF file. If you are prompted, save the file.
  2. When you are finished with this tutorial, close the TRS window.

In this tutorial, you learned how to create, edit, and download a simple bar chart from your data. While the data for this tutorial was small and easy to understand, the data you work with each day will undoubtedly be much more complex. Using the charting options provided in TRS can help you gain insight to your data in ways that would be quite difficult to see otherwise. Feel free to explore and play with the other customization settings. This will help you learn what else is available so that you can fully customize your charts.