Start of Wikimedia Commons page for RCraig09 (talk) 21:07, 30 January 2009 (UTC)

Excel .xlsx spreadsheets that automatically generate XML code for .SVG graphics edit

Click at right to go to User:RCraig09/Excel to XML for SVG
Transcluded from User:RCraig09/Excel to XML for SVG:
 
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)

Click HOW TO for detailed explanation.
Click HERE (else HERE) to download the spreadsheets.
  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)
Transcluded from User:RCraig09/Warming stripes in shapes
An Excel .xlsx spreadsheet automatically+ generated the XML code for the following SVG images:
  • The spreadsheet user can toggle a switch to reverse the order of data, so red is in the center (or left side of first graphic) and blue is at the outside (or right side of first graphic).
  • The spreadsheet user can choose height and width (in pixels), to compress or expand shape vertically and horizontally, for example, to change an ellipse to a circle or a rectangle to a square.
  • To download the spreadsheet, go to User:RCraig09/Excel to XML for SVG.
  • Don't try to edit inside this colored box; make any comments about the spreadsheets or graphics at User talk:RCraig09RCraig09 (talk) 20:43, 20 May 2021 (UTC)

Gallery (manual) edit

"Wikipedia Commons Gallery"(here) is sometimes fritzy.
Manually created gallery of uploads (◣OW◢ = "Own work": from-scratch file generation or personally took picture):

Climate change — Others' work edit

Click at right to show/hide images

NASA Vital signs of the planet edit

Click at right to show/hide images

Climate change — Own work ◣OW◢ edit

Click at right to show/hide images

Deforestation, habitat loss, etc. ◣OW◢ edit

Click at right to show/hide images

Emissions-related, carbon budget, etc. ◣OW◢ edit

Click at right to show/hide images

— Purely temperature or heat charts ◣OW◢ edit

Click at right to show/hide images

— Global surface temperature, same month, year by year ◣OW◢ edit

Click at right to show/hide images

— Temperature records project ◣OW◢ edit

Click at right to show/hide images

Effects of climate change, incl. Feedbacks (not including purely temperature or heat charts) ◣OW◢ edit

Click at right to show/hide images

— Polls, consensus, public opinion, politics, denial, psychology, Google Trends searches, etc ◣OW◢ edit

Click at right to show/hide images

— Warming stripes — own work ◣OW◢ edit

Click at right to show/hide images

Alternative/renewable/green energy/transition edit

Click at right to show/hide images


Projects done for Graphics Lab workshops edit

Flatten the curve, raise the line, pandemic resurgence, coats of arms, flags, pennants, roadsigns, head/neck diagram (Danish), synthetic aperture radar, time of flight, New Zealand gov't, signatures ...

Click at right to show/hide images

Fair-use projects:

 

— Fair use images at en.wp



— Pandemic edit

Click at right to show/hide images

Flags, shields, coats of arms, logos edit

Click at right to show/hide images


See also Projects done for Graphics Lab workshops.

Fair use projects:

 




Scenic edit

Click at right to show/hide images

Performing artists edit

Click at right to show/hide images

Yanni and his artists edit

Click at right to show/hide images

Psychology edit

Click at right to show/hide images

Medal of Honor Recipients edit

Click at right to show/hide images

None are ◣OW◢

USS Savannah edit

Click at right to show/hide images

Bowling edit

Click at right to show/hide images

— Bowlers edit

Click at right to show/hide images

— Bowling photos, images, and videos edit

Click at right to show/hide images

— Bowling diagrams edit

Click at right to show/hide images

— Bowling graphs, charts and maps edit

Click at right to show/hide images

— Bowling documents, patents and articles edit

Click at right to show/hide images


None are ◣OW◢

Misc. Historical newspaper, magazine articles, ads, posters, etc. edit

◣Vintage◢

— Through 1799 edit

Click at right to show/hide images

— 1800-1849 edit

Click at right to show/hide images

— 1850-1899 edit

Click at right to show/hide images

— 1900- edit

Click at right to show/hide images

RMS Empress of Ireland edit

Click at right to show/hide images

— Montana as an historical subject edit

(does not include Montana newspaper articles on another subject, or modern scenic pics)

Click at right to show/hide images

— Susan B. Anthony edit

Click at right to show/hide images

— Before-and-after image editing edit

Click at right to show/hide images

— Bernadette Soubirous (Lourdes) edit

Click at right to show/hide images

— Gimbels edit

Click at right to show/hide images

RMS Titanic edit

Click at right to show/hide images

w:Message in a bottle edit

~None are ◣OW◢

Click at right to show/hide images

Video statistics edit

Click at right to show/hide images

Gun control and other homicide-related edit

Click at right to show/hide images

Inequality, social issues edit

Income and wealth inequality, ACLU funding, immigration, economic stratification

Click at right to show/hide images

Miscellaneous graphs, charts, flowcharts, maps, screenshots edit

Hurricanes, tobacco use by age, Trump statement veracity, income and wealth inequality ...

Click at right to show/hide images

Miscellaneous edit

Click at right to show/hide images

Sound files edit

Sound files don't seem to display properly if they're in collapsible text.

  • — ◣OW◢ 17:57, 30 November 2019 — "Warming notes" (piano)

  • — ◣OW◢ 04:54, 29 April 2020 —"Annapolis" spoken word.

  • — ◣OW◢ 04:59, 29 April 2020 — "Helena" spoken word.

  • — ◣OW◢ 21:11, 13 May 2020 — "Reuters" spoken word.

  • — ◣OW◢ 20:35, 27 May 2020 — "Anne Arundel" spoken words.

  • — ◣OW◢ 18:16, 31 May 2020 — "Yanni" spoken word.

  • — ◣OW◢ 21:44, 30 August 2020 — "Cassiopeia" spoken word

  • — ◣OW◢ 05:31, 20 September 2020 — "legerdemain" spoken word

  • — ◣OW◢ 21:34, 26 September 2020 — "hyperbole" spoken word

  • — ◣OW◢ 21:39, 26 September 2020 — "hyperbolic" spoken word

  • — ◣OW◢ 21:42, 26 September 2020 — "hyperbola" spoken word