What preparation is required to load Excel and Google spreadsheets?

Preparation is simple. Use the following simple rules to prepare your Excel sheet or Google spreadsheet:

  1. A data series is identified as a single column of data in a speadsheet. This means that the first cell of each respective column must be the data series name. If your data series name was Country, as in the example below, then the content within Row 2 and all succeeding rows within the same column will be China, Russia, Brazil, France and Italy.

     

  2. You can upload an unlimited number of data series. To ensure a successful upload, structure your data in the aforementioned way. Continuing on our previous example, Column A, Column B, Column C and Column D are separate unique data series. The content in Row 1 are the data series names for each respective column, which means that each data series is named Country, Shipping Volume, Shipping Costs, and Export Fees. The values within Row 2 through Row 6 for a given column are grouped together.

  1. The cells within your spreadhsheet can be expressed in final values or as values determined by formulas. When using formulas, only one restirction holds - the formulas must only refer to cells within the first sheet.
  2. Data should be aggregated or tabulated.
  3. The category column that you plan to use on the chart should not have duplicates.
  4. Data values can be formatted as percentages (37.5%) or as decimals (0 .375). Note: If your data values are formatted as percentages, be sure to turn your percentage formatting on within the Data Editor in the studio. When you are in the studio, select View Data in the top menu. When the Data Editor appears, click on the column headers which were formatted with percentage signs in your original file, to reveal a menu of actions. Turn the percentage formatting on. Similarly, if you have data values in percent format and would like to display in decimals instead, simply follow the same steps and turn the percentage formatting off. Setting the percentage formatting on or off is only necessary if you are using an Excel spreadsheet. Disregard this note if you are using a Google spreadsheet; uploading percentage formats will automatically transfer the percentages into the tool.

Label Wrapping Tips

If you have long labels, you can plan to strategically format them within your Excel file for maximum control. Use the command "Alt+Enter" within each cell where you'd like the text to carry into the next line. The structure you set within your file will dictate how they display along the chart's axis.

You may also do a variety of things in the studio to make them chart-friendly along your category axis:

  1. Try increasing the width or height of your chart area to make more room for your labels.
  2. Click on the category axis* of your chart to reveal your formatting options in the Chart ToolBox. Adjust your angle rotation, label dropping and label wrapping options to optimize how well your labels fit.

* Your category axis will be the horizontal axis if you are using a column chart, 100% stacked column chart, stacked column, line chart, or combo chart. Your category axis will be the vertical axis if you are using a bar chart, 100% stacked bar chart, stacked bar or vertical line chart.

Label Order

Compare the order of the cell phone use categories in the Excel spreadsheet with the order they appear along the vertical category axis in the images below. As you may notice what is listed last in Column A of your spreadsheet, leads the list along the axis. This is a unique behavior which only occurs when the vertical axis is your category axis (learn more). If the first item you listed in your category column (Cell A1) is what you'd like to display at the top of your axis, reverse the order so that what should be listed last, is in Row 1 of your spreadsheet.

Note: This will not occur if the category axis is organized horizontally. Learn more.