2
$\begingroup$

I don't really know if I'm posting in the right place but I hope so.

I'm writing my bachelor degree, and I collected some data about fonts and language support.

At the moment, all my data is stored in an excel spreadsheet, in the form of:

  • Column: language support (e.g. Cyrillic, Cyrillic extended, Arabic, Vietnamese, Devanagari, etc)
  • Rows: names of the fonts that supports that language, up to 890

Note that some of there fonts, even though they occur only one per columns, they may appear several times in different columns (e.g. Noto Sans will appear in Latin, Latin Extended, Cyrillic, Cyrillic Extended, Simplified Chinese and many others; while others e.g. Padauk will only appear under Myanmar since that font may not support all Latin characters).

What I would like to do is to put these data in visual form, ideally via a Venn Diagram that displays how much each language is supported (area) and how many language are supported at the same time by a given font (opacity overlapping). I don't need to process this plotting step inside excel, I just need to get the data of how many fonts per intersection are there (e.g. latin and cyrillic gives 100, latin and arabic gives 80, latin and arabic and cyrillic gives 10 ... up to latin and cyrillic and arabic and devanagari and [n] gives 0).

I thought I could have parsed these data with javascript and json but I can't get to properly convert my excel file to json in a fashion that I can really use.

Any suggestion in warmly welcomed and I really thank you in advance

$\endgroup$
3
  • 1
    $\begingroup$ Could you add a snippet of the data and a sketch of the Venn diagram? I couldn't quite understand your intention, but I might help, if I understand it better. $\endgroup$
    – oezguensi
    Dec 21, 2018 at 15:24
  • $\begingroup$ @oezguensi of course, thank you! My data is organized as in this Google sheet, for the sake of example and simplicity I only shared the first 30 lines. The kind of result I'm looking for is this. $\endgroup$ Dec 23, 2018 at 12:31
  • $\begingroup$ You can try to use SmartArt in Excel. Go To Insert SmartArt-->Relationship --> Venn Diagram $\endgroup$ Jan 21, 2019 at 12:41

1 Answer 1

1
$\begingroup$

If you are famialiar with R, you can use this library: VennDiagram Without glimpse of your data its hard to help more, but with this library you can build simple Diagrams like this : enter image description here

Or something insane like this: enter image description here

You can find boht examples in the library code examples.

Hope this helps!

$\endgroup$
2
  • $\begingroup$ I'm not familiar with R, since I'm a graphic designer, but I will definetly give a look. Thank you! $\endgroup$ Dec 23, 2018 at 12:32
  • $\begingroup$ @GabrielRambaud Can you draw ( in paint even) how it should look based on the data you have shared ? it would be good to have visual instraction $\endgroup$ Dec 23, 2018 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.