Wikipedia:Graphics Lab/Illustration workshop/Archive/Apr 2021

This page, part of the Graphics Lab Wikiproject, is an archive of requests for 2021.
Please do not edit the contents of this page. You can submit new requests here.

Archives of 2021:
January, February, March, April, May, June, July, August, September, October, November, December

Hear ye! Excel .xlsx spreadsheets that automatically generate XML code for .SVG graphs

Warming stripes
(five examples compared)

Warming stripes bar chart

Bar chart (vertical)

Pie chart

Line charts

Scatterplot

I've uploaded .xlsx (Microsoft Excel) spreadsheets that automatically generate XML code for charts in SVG format.

You simply paste or enter your data into the spreadsheet, and specify image dimensions, number of grid lines, font sizes, etc. The spreadsheet instantly and automatically generates a column of XML code that you simply copy and paste into a text editor and save as an ".svg" file. The spreadsheets produce lean SVG code, avoiding the "extra stuff" that Inkscape inserts. They should save you time in creating SVG charts.

Feedback and suggestions on my talk page are welcome. RCraig09 (talk) 23:41, 19 February 2021 (UTC)[reply]

Click HOW TO for detailed explanation.

Click HERE (else HERE) to download the spreadsheets.

Example SVG files: Category:SVG diagrams created with spreadsheet.

Warming stripes — Accepts a single dataset and converts to SVG code portraying Ed Hawkins' warming stripes graphics. User chooses vertical or horizontal stripes; normal or reverse data ordering; or from a variety of geometric shapes (updated 17 May 2023). . . . . Click here to see examples of warming stripes embedded in different shapes.
Warming stripes bar chart — Accepts a single dataset and creates a conventional bar chart whose individual bars/columns are coloured according to Dr. Hawkins' warming stripes colour scheme. Alternate option: choose one colour for ascending bars and another colour for descending bars. (updated 28 August 2023)
Line charts — Accepts up to six datasets. (updated 30 August 2023)
Vertical bar charts (column charts) — Accepts up to six datasets. Toggle between clustered and stacked charts; user can adjust "Yfloor"—the Y level (usually=0) from which columns rise or fall; user chooses to keep or ignore negative input values. (updated 27 August 2023)
Horizontal bar charts — Accepts up to six datasets. Toggle between clustered and stacked charts; user can adjust "Yfloor"—the value (usually=0) from which bars extend; user chooses to keep or ignore negative input values. (updated 27 August 2023)
Scatter plots — Accepts up to five datasets. (updated 28 August 2023)
Pie charts — Accepts a single dataset of up to 36 items. (updated 17 May 2023)
Variable-width bar charts — Accepts up to six datasets; is like "Vertical bar charts", above, but user can choose different widths for different bars. (updated 27 August 2023)

User:RCraig09: All well and good, but this is for proprietary software, which it is preferable not to promote. Can you do the same for LibreOffice Calc? Regards, DesertPipeline (talk) 12:21, 8 April 2021 (UTC)[reply]

Also, can you trim the template you use here to remove the whitespace below it? DesertPipeline (talk) 12:23, 8 April 2021 (UTC)[reply]

@DesertPipeline: Thanks for your observation. I chose Excel because it's the most-used spreadsheet program, not to "promote" it. (Before today, I had never heard of LibreOffice.) Experimentally I imported some of my .xlsx Excel (Excel-for-Mac) files into Apple's "Numbers" spreadsheet, and there was some undesirable difference in text rendering, and complete loss of the "Data... validation" function, for starters. Making new families of spreadsheets would be very time-consuming, and would require duplication (triplication...) of effort with each improvement. I don't see this project on my horizon at this time, though you have brought up a good point. At least the Excel spreadsheets are importable to at least some free software. —RCraig09 (talk) 14:55, 8 April 2021 (UTC)[reply]

Liberal Democratic Party of Australia logo vectorized

Article(s): Liberal Democratic Party (Australia)
Request: Currently there is no .svg version of the lib dems logo avaliable that I can find, would be greatly appreciated if someone could make a vector version of it for the wikipedia page
Discussion

Royal Standards of Prince Philip (1951–1952)

Prince Philip's standard from 1952 to 2021.
Princess Elizabeth's standard from 1944 to 1952 (England, Northern Ireland, Wales).
Princess Elizabeth's standard from 1944 to 1952 (Scotland).

Article(s)

List of British flags, List of Scottish flags, Royal Standard of the United Kingdom.

Request

Could someone please an create SVG file of the Royal Standard used by Prince Philip in most of the United Kingdom from 1951–1952, as seen here, which is effectively a combination of the first two images provided above. And could someone also create an SVG file of the Royal Standard used by Prince Philip in Scotland alone from 1951–1952, which would be mostly the same as the one in the link, only with the third above image instead of the second one. Thanks. Snow Lion Fenian (talk) 19:07, 9 April 2021 (UTC)[reply]

Discussion

This is the standard of Queen Elizabeth back when she was Heiress-presumptive and Duchess of Edinburgh from 1949 to 1952. Men do not impale their arms with those of their wives.

@Sodacan: So what are you saying here, exactly? Snow Lion Fenian (talk) 02:04, 10 April 2021 (UTC)[reply]

The standards you linked to and want made belongs to Elizabeth and not Philip. If you still want them I can still make. Sodacan (talk) 02:46, 10 April 2021 (UTC)[reply]

@Sodacan: Alright then, yes, that'd be great. And thanks for clearing that up. Snow Lion Fenian (talk) 15:44, 10 April 2021 (UTC)[reply]

@Snow Lion Fenian: I believe that standard is a hoax. Sodacan is correct that male consorts do not impale their arms in that manner. A royal standard is a banner of the bearer's coat of arms, and Prince Philip's coat of arms were first File:Arms of Philip Mountbatten (1947-1949).svg and then File:Arms of Philip, Duke of Edinburgh.svg. As a consort, Prince Philip would have only received the right to a personal standard once the then Princess Elizabeth became Queen. That is similar to how Lady Diana and the Duchess of Cornwall did/do not have personal standards, until Prince Charles becomes King. Fry1989 ^eh? 16:03, 10 April 2021 (UTC)[reply]

Royal Standard of Queen Adelaide (1830–1849)

British Royal Standard (1816–1837)
Shield from the arms of Adelaide of Saxe-Meiningen (including the 1816 RS)

Article(s): List of British flags, Royal Standard of the United Kingdom
Request: Can someone please create an SVG file of the Royal Standard of Queen Adelaide (wife of King William IV), used from 1830 to 1849, as seen on this page here. It would involve combining various elements from both of the above images. Thanks. Snow Lion Fenian (talk) 18:29, 10 April 2021 (UTC)[reply]
Discussion

Wappen Werra-Meissner-Kreis and Wappen Landkreis Börde

Coat of arms of Werra-Meißner-Kreis
Coat of arms of Landkreis Börde

Article(s): Werra-Meißner-Kreis; Börde (district)
Request: Please make a SVG version of these files? Thanks. -- SpinnerLaserzthe2nd (talk) 02:05, 7 April 2021 (UTC)[reply]
Discussion

Translation of Prince Philip's family tree

German	English
Albert v. S.C. u. G.	Albert Prince Consort
Victoria	Victoria
Alexander v. Hessen-D.	Alexander of Hesse
Julia Hauke Gräfin	Julia Hauke
Ludwig IV. von Hessen	Louis IV of Hesse
Alice	Alice
Edward VII.	Edward VII
Alexandra v. Dänemark	Alexandra of Denmark
Franz Herzog v. T.	Francis Duke of Teck
Mary v. Cambridge	Mary of Cambridge
Ludwig v. Battenberg	Louis of Battenberg
Viktoria v. Hessen-D.	Victoria of Hesse
George V.	George V
Maria von Teck	Mary of Teck
Andreas v. Griechenl.	Andrew of Greece
Alice v. Battenberg	Alice of Battenberg
George VI.	George VI
Elizabeth Bowes-Lyon	Elizabeth Bowes-Lyon
Philip Mountbatten	Philip Mountbatten
Elizabeth II.	Elizabeth II

German version

Article(s): Prince Philip, Duke of Edinburgh#Marriage
Request: Please translate the family tree of Prince Philip. --Leyo 08:55, 20 April 2021 (UTC)[reply]
Discussion: Leyo You would have to provide the translation here;

from, to
or in a similar way, thanks. --Goran tek-en (talk) 16:33, 25 April 2021 (UTC)[reply]

Unfortunately, I am not at all a royal expert and not even British or a native speaker. Therefore, there would be a risk of an incorrect translation, especially when it comes to acronyms. I assume that there are some British users around here. --Leyo 08:36, 26 April 2021 (UTC)[reply]

Celia Homeford has completed and proof-read the translations. Hence, the family tree figure is ready for being created in English. --Leyo 15:02, 5 May 2021 (UTC)[reply]

Request taken by Goran tek-en (talk) 17:21, 11 May 2021 (UTC). But it might be some time before I actually can work on it. If you think to much time has passed just ping me, thanks. --always ping me--Goran tek-en (talk) 17:21, 11 May 2021 (UTC)[reply]

Leyo Now you can find it here Commons:file:Elizabeth_II_Philipp-en.svg. If you are happy with this please put the code {{tl|resolved|1=~~~~}} on this request so it can be archived, thanks.

Done --always ping me--Goran tek-en (talk) 12:10, 15 May 2021 (UTC)[reply]

[PNG to SVG] Star Wars Day logo

Logo for Star Wars Day
SVG

Article(s): Star Wars Day
Request: Can someone please convert this logo from PNG to a SVG? –WPA (talk) 15:30, 3 May 2021 (UTC)[reply]
Discussion

Done Krupadeluxe (talk) 13:44, 10 May 2021 (UTC) Ten days after completion; can be archived. {{resolved}}[reply]

Request: Transparent SVG

image:Transparent.gif: 1x1 transpareng GIF
image:Transparent.png: 1x1 transparent PNG
1x1 transparent SVG

Reason: for compositing imagery on Wikipedia; just as how the PNG and GIF files are currently used
Request: Please create a minimalist transparent SVG file (ie. a 1x1 SVG transparent raster; or some other encoding that is more efficient (undefined size transparent only file?) ; ex. a -- 67.70.27.180 (talk) 03:06, 24 May 2021 (UTC)[reply]
Discussion

Done Leaving the file completely undefines yields an unwanted SVG logo of sorts, as it turns out, so I just used a 1x1 document size. Pbrks (talk) 03:29, 24 May 2021 (UTC)[reply]

Thanks. {{resolved}}