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. |
Hear ye! Excel .xlsx spreadsheets that automatically generate XML code for .SVG graphs
![](http://upload.wikimedia.org/wikipedia/commons/thumb/0/0f/20210601_Spreadsheet_automatically_generates_XML_code_for_SVG_graphics_-_flow_chart.svg/290px-20210601_Spreadsheet_automatically_generates_XML_code_for_SVG_graphics_-_flow_chart.svg.png)
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)
- 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)
- Also, can you trim the template you use here to remove the whitespace below it? DesertPipeline (talk) 12:23, 8 April 2021 (UTC)
- @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)
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)
- 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)
- 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)
- @Sodacan: Alright then, yes, that'd be great. And thanks for clearing that up. Snow Lion Fenian (talk) 15:44, 10 April 2021 (UTC)
- 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)
- @Sodacan: So what are you saying here, exactly? Snow Lion Fenian (talk) 02:04, 10 April 2021 (UTC)
- @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)
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)
- 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)
- 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)
- 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)
- 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)
- 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)
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)
- 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)
[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)
- Discussion
Done Krupadeluxe (talk) 13:44, 10 May 2021 (UTC)
Ten days after completion; can be archived. {{resolved}}
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)
- 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)
Thanks. {{resolved}}