blankblank blank




Excel Add-On For Map And Data Visualization



Claude Henri-Meledo writes to tell me about BeGraphic Lite, a free data visualization tool for Microsoft Excel. I don’t currently have easy access to Microsoft Excel (I’m working in OpenOffice exclusively), so I can’t try it out, but it looks interesting. It apparently does a wide variation of data graphics, not just maps; these include:

cascade chart / waterfall chart, marimekko / mekko chart, sankey diagram, dynamic diagram, pivot diagram, powerpivot charts, pivot chart, ishikawa cause-effect diagram, BCG matrix, ADL matrix, McKinsey 7S, RB profiler, DuPont chart, choropleth map, swot analysis model, vector glyph, business chart, business graph, business graphics, professional excel chart, mini-graphs, micro-charts, sparkline for excel, excel gauges, strategic maps, strategy map, dashboard software, moving bubble, motion chart, trend analyzer, scada system, control room, make a custom map in Excel, thematic map in PowerPoint, dynamic sales territories, mapping tool, geographical information system in excel2010, choropleth map,  and any innovative charts…

A few sample map screenshots from the website:

France

Disney

BeGraphic LIte works with the free vector graphic map data available at d-maps.com, which now has 7500 maps available (up from 4000 when I posted about the site in August 2009). Edit: You need to download the files in WMF format. There’s a Pro version of BeGraphic in the works for later this year, but the Lite version will still be free and available.


Looking for something else? Enter some keywords below, then click "Search".    




3 Responses to “Excel Add-On For Map And Data Visualization”


  1. 1 Ross

    For those without Excel, it might be worth trying Go-oo, an OpenOffice variant similar to Novell’s version, that supports VBA. I am assuming that this has been used to get Excel to do the ‘magic’. The VBA in Go-oo may not be 100% complete though.
    A new version of Go-oo was released on Feb 10th, version 3.2.10 for Windows users. If you use non-US languages, you might want to wait a week and get the patched 3.2.11 version.

    If anyone tries this and is successful, post here to let us know. Thanks.

  2. 2 epicsystems

    Dear Sir,

    I have the pleasure to brief on our Data Visualization software
    “Trend Compass”.

    TC is a new concept in viewing statistics and trends in an animated
    way by displaying 5 axis (X, Y, Time, Bubble size & Bubble color)
    instead of just the traditional X and Y axis. It could be used in
    analysis, research, presentation etc. In the banking sector, we have
    Deutsche Bank New York as our client.

    This a link on weather data :

    http://www.epicsyst.com/test/v2/aims/

    This is a bank link to compare Deposits, Withdrawals and numbers of
    Customers for different branches over time ( all in 1 Chart) :

    http://www.epicsyst.com/test/v2/bank-trx/

    Misc Examples :

    http://www.epicsyst.com/test/v2/airline/
    http://www.epicsyst.com/test/v2/stockmarket1/
    http://www.epicsyst.com/test/v2/tax/
    http://www.epicsyst.com/test/v2/football/
    http://www.epicsyst.com/test/v2/swinefludaily/
    http://www.epicsyst.com/test/v2/flu/
    http://www.epicsyst.com/test/v2/babyboomers/
    http://www.epicsyst.com/test/v2/bank-trx/
    http://www.epicsyst.com/test/v2/advertising/

    This is a project we did with Princeton University on US unemployment :
    http://www.epicsyst.com/main3.swf

    A 3 minutes video presentation of above by Professor Alan Krueger
    Bendheim Professor of Economics and Public Affairs at Princeton
    University and currently Chief Economist at the US Treasury using
    Trend Compass :
    http://epicsyst.com/trendcompass/princeton.aspx?home=1

    Latest financial links on the Central Bank of Egypt:

    http://www.epicsyst.com/trendcompass/samples/Aggregate-balance-sheet/
    http://www.epicsyst.com/trendcompass/samples/balance-sheet
    http://www.epicsyst.com/trendcompass/samples/banks-deposits-by-maturity/
    http://www.epicsyst.com/trendcompass/samples/egyptian-banks/
    http://www.epicsyst.com/trendcompass/samples/currency-by-denomination/

    I hope you could evaluate it and give me your comments. So many ideas
    are there.

    You can download a trial version. It has a feature to export
    EXE,PPS,HTML and AVI files. The most impressive is the AVI since you
    can record Audio/Video for the charts you create.

    http://epicsyst.com/trendcompass/FreeVersion/TrendCompassv1.2_DotNet.zip

    All the best.

    Tarek Y Aziz
    Marketing Manager
    Epic Systems
    http://www.epicsyst.com

  3. 3 Denis

    For Excel Add-On For Map And Data Visualization, you should have a look to our website resources
    http://www.deixsys.com

Comments are currently closed; feel free to contact me with questions/issues.