toggle menu

How to organize your data for each chart type

You can import XLS, XLSX or CSV (comma delimited) type spreadsheets containing numerical data organized in a table. Your data will convert correctly if it is structured like the examples shown below.

If you don’t have the possibility to create an XLS, XLSX or CSV file, use the ‘New’ button to create your data sheet inside MyChartlr.

Download and import sample data

To make life easier for you, we put all the above data examples into an Excel file which you can download here.

After importing this file into Chartlr, the various data sheets are accessible via the dropdown in the Data sheet tab.

Download sample data

Frequently asked questions

Here are the top 10 questions users asked us so far. If you have a different question, please use the contact link in the footer of the page.

  1. I can’t upload my data sheet

    Chartlr checks the structure and integrity of your data upon import. Not all data sheet layouts will be parsed correctly. The section at the top of this page shows how your data should be structured for good results.

  2. Which file import formats are supported?

    At this time, Chartlr supports the import of XLS, XLSX and CSV (comma separated) file formats. We’re working on support for other data structures like Google Sheets.

  3. Can I easily change the order of colors?

    Sure! Simply click on one of the item color chips, keep the mouse button depressed and drag the chip to the desired location. The color order in the chart or graph will update accordingly.

  4. I want to move the legend to a different position

    In our Student and Professional Plans, Chartlr gives you 3 options for legend placement. Top right, bottom right and none. In the Expert Plan you have more control over the placement of the legend and other elements like title, subtitle and source mention.

  5. How do I clear the data sheet and import new data?

    If you import a new data sheet, it will automatically overwrite previous information in the data sheet tab.

  6. How can I delete a chart from my ChartCloud?

    Go to your ChartCloud by clicking on your name in the top righthand corner of your screen. Search the chart you would like to delete and click on it. The selected chart gets a blue outline and two buttons appear: an open button and a delete button. Click the delete button to erase the chart from your ChartCloud.

  7. If I save a chart to my ChartCloud, will it also save the data?

    Certainly. The connected data sheet will automatically be saved with your chart. When you reload the chart into the ChartApp, the connected data sheet will be loaded into the data sheet tab and you can easily update the data this way.

  8. I want to add a trend line to my column chart. How do I do this?

    Currently, this is not supported by Chartlr. But there is a work-around. Use the 2-axis chart type to add a trend line to your column chart. You will have to do the math for the trend line yourself though...;)

  9. I want to use two vertical axes with different values in my chart. How do I do this?

    You can use the 2-axis chart type for this. Check the section at the top of this page to see how to structure your data for this chart type.

  10. The labels of my x-axis overlap. How do I rotate them?

    Currently, this is not supported by Chartlr, except in the Waterfall chart. We may add this functionality to other chart types soon, based on popular demand. What you can do in the meantime: select the bar chart from the chart type accordion. The long labels will now move to the y-axis where there is more space.