https://bugs.documentfoundation.org/show_bug.cgi?id=160398
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stephane.guillou@libreoffic | |e.org --- Comment #3 from Stéphane Guillou (stragu) <[email protected]> --- Created attachment 193371 --> https://bugs.documentfoundation.org/attachment.cgi?id=193371&action=edit sample XLSX with choropleth chart created in MS Office This simple choropleth map was created with MS Excel (desktop). Note that it needed to send data to Bing in order to create it, so not everything is done locally. When opened in LO, the chart is replaced by the generic placeholder "This chart isn't available in your version of Excel". No idea how such a chart is defined in OOXML, but supporting displaying it could be a separate ticket to supporting the creation / editing of such charts. I note that dealing with spatial data is quite the challenge. In my opinion, as a minimum, an implementation of a new chart type would have to support: - inclusion of a generic global shapefile of state borders (which might bring in some geopolitical/cultural debate) - could be from Natural Earth: https://www.naturalearthdata.com/ - sensible detail level of such a shapefile, with rendering adapting to different zoom levels - at least two chart types: choropleth and point/circles - automatic matching of country names or codes to the features in the shapefile - recognition of lat/lon coordinates for point data - styling of borders, fills, points... - set of discrete and continuous colour scales to choose from - a small set of projection options - labeling of features (e.g. country names on or off) And all that preferably online. -- You are receiving this mail because: You are the assignee for the bug.
