Powerful data analysis.
Beautiful reports.

Join thousands of users who build beautiful data slideshows
for their customers and colleagues.

Sign up for FREE

Tag: Excel

Building a map chart!

We just shipped a cool new feature for your geography charts!

You can now locate your data on Google maps. Let’s have a quick look how to do it…

1) Create a new data presentation

2) Connect some data to your slideshow

For this example, we uploaded our data from a Google spreadsheet.

3) Create a map chart

All you have to do is select the map chart and drag it a media zone in your slideshow.

4) Add some data to your map chart 

The Values field should contain the data item you’d like to measure. The Location field should contain the Geography column that will be used to split your data.

You can use almost everything that looks like a geographical data points: ZIP codes, country names, adresses, nationalities, etc. Thanks to the power of the Google maps engine, Jolicharts will find the right way to place your data points on the map.

 

 

5) Select a zoom level

In the Settings tab, you can switch between different continents, countries and regions to be displayed.

 

And here it is. All done!

 

                   

Jolicharts vs. Excel: pivotables have become so 1990s

Why you should use Jolicharts instead of a good old pivot table in Excel to generate your charts? Not clear to you? Here are some key benefits to one of the most frequently asked questions by people not yet familiar with self-service business intelligence tools.

- Collaborative sharing of your dashboards (Google Drive-style approach as opposed to MS Office)
– You can design clean and user-friendly design for your charts and dashboards
– Possibility to cross multiple datasources (for the moment XLS and CSV only, but soon web services and databases)
– You may publish information in one click on the web
– Easy to embed charts and dashboard on external websites
Capable of handling big amounts of data (up to 1GB for the moment, and a lot more very soon)

Last, we at Jolicharts don’t see Microsoft Excel as a competitor at all. To us, Microsoft Excel is a wonderful platform to build upon, with a huge-issima installed based. We acknowledge a good chunk of our users are very familiar with Excel – some of them are Excel power users, and we’re doing our best everyday to make Excel datasources integrate seamlessly with Jolicharts. In a way, Jolicharts is the online, social extension of your spreadsheets.