https://bugs.documentfoundation.org/show_bug.cgi?id=160398
Eyal Rozenberg <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- URL| |https://en.wikipedia.org/wi | |ki/Choropleth_map --- Comment #5 from Eyal Rozenberg <[email protected]> --- (In reply to Richard M from comment #0) > ... plot data on a World Map. For example given a dataset > of [COUNTRY CODE, COUNT] you could > see a "Count" over each country code with highlights. This would be useful for sure, but - the question is whether your specific request actually requires a new kind of chart, or can be a variation on an XY (In reply to Stéphane Guillou (stragu) from comment #3) > Created attachment 193371 [details] > sample XLSX with choropleth chart created in MS Office For those not familiar with the term: https://en.wikipedia.org/wiki/Choropleth_map > When opened in LO, the chart is replaced by the generic placeholder "This > chart isn't available in your version of Excel". Do we have an "Excel feature parity" tracker meta-bug? I couldn't find one... > 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. Are you sure? I would say keep it as a single bug, unless a developer tells us they can fix only one of the two without the other. > I note that dealing with spatial data is quite the challenge. Maybe in the most general case. But - in a simpler case, wouldn't an "XY+Value" chart type (bug 160411), plus background map, be enough? > 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/ Call them regions probably. And we could either bundle something by default or be able to download from known public locations - perhaps "bundling" some common sources for this. Debates may certainly happen, but the variety of sources could mitigate them. > - 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 What kind of recognition do you mean? ... Hmm, perhaps this would relate to projection. > - styling of borders, fills, points... > - set of discrete and continuous colour scales to choose from We already have that for conditional formatting, we should probably leverage the commonality here. > - a small set of projection options Hmm... do you really want LO to "know" about 3D points and 2D projections? As opposed to only recognizing 2D shapes, i.e. pre-projected shapes? > - 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.
