Wikipedia

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

< Wikipedia:Graphics Lab | Illustration workshop | Archive
Archive

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

 
General concept above; examples below.
 
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.
  1. 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.
  2. 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)
  3. Line charts — Accepts up to six datasets. (updated 30 August 2023)
  4. 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)
  5. 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)
  6. Scatter plots — Accepts up to five datasets. (updated 28 August 2023)
  7. Pie charts — Accepts a single dataset of up to 36 items. (updated 17 May 2023)
  8. 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

 
Lib Dems Aus logo


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]
  •  
    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

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}}

Retrieved from "https://en.wikipedia.org/w/index.php?title=Wikipedia:Graphics_Lab/Illustration_workshop/Archive/Apr_2021&oldid=1117036398"