Create a Top N chart from a csv file
Need to create a Top 5 chart from a csv file in a hurry? Want to include items outside the Top 5 in an Others category? InstaCharts makes it easy.
1. Load your spreadsheet
Click New sheet and select the spreadsheet from your device. Click OK and the spreadsheet will be processed and displayed in the Data tab. InstaCharts automatically detects the column type and formatting for each spreadsheet column, saving you time from setting it yourself.
2. Edit your chart
A Top N Chart with remaining items in an Others category
Once the spreadsheet data has been processed, a chart is automatically produced on the Chart tab using default settings. Edit the chart settings to customize the data shown in the chart.
A bar chart or stacked bar chart is recommended to visualize rankings.
The x and y-axis can be selected from any column in the spreadsheet. Certain columns will be recommended for the x or y-axis based on the data within the column.
For ranking, it’s recommended to choose numerical values on the y-axis and categorical data (like names) on the x-axis. If you choose a stacked bar chart, you’ll be able to choose a group column to highlight subsections within each bar of the chart.
InstaCharts automatically performs aggregation on your data in order to produce a chart. You can select the mathematical function used to aggregate the chart data. Here are some of the available options:
- Sum Adds all values together
- Count Counts number of rows
- Average Calculates the average of all values
- Median Finds the middle value
- Min Finds the smallest value
- Max Finds the largest value
- Distinct Counts the number of different values
- Valid Counts rows with a value. Useful for validating data in the spreadsheet.
- Missing Count of rows missing a value. Useful for validating data in the spreadsheet.
Choose the function that best describes what you wish to illustrate in the chart. Sum and average are common choices for a Top N chart.
Once a chart type and axis have been selected, it’s time to choose limits. Click Limit Items on the sidebar, then click the checkbox to enable limits. The default number of items is set to 6, but it can be bumped up or down depending on how many top items you wish to show in the chart. Choose rank by largest values to show the top values in the plot, or rank by smallest values to showcase the smallest items. You can optionally group the remaining items into an “All Others” category by clicking the associated checkbox.
That’s it! Export your chart to share your findings with others. You can also view and download the data produced to create the chart.
The demo mode is limited to process a maximum of 500 rows per spreadsheet. Join the InstaCharts waitlist to be allowed into the main app, bypassing the restrictions of demo mode.
Give it a try
InstaCharts is a powerful tool that can help you create professional-looking charts in seconds. Give our demo a try!