User:RCraig09

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

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 show/hide links to xlsx files
Transcluded from User:RCraig09/Excel to XML for SVG:
General concept above; examples below.
Warming stripes (composite)
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 your X-Y 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. It produces lean SVG code, avoiding the "extra stuff" that Inkscape inserts, and should save you time.

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 to see examples of warming stripes embedded in different shapes.
  • Warming stripes bar chart (download v1.0) Creates a 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. One dataset only (updated 31 August 2021).
  • Line charts (download v2.2)— Accepts up to five datasets for LINE charts (example at right) (updated 12 June 2021).
  • Vertical bar charts (column charts) (download v1.1)— Accepts up to six datasets for VERTICAL BAR CHARTS (COLUMN CHARTS)—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 (example at right) (updated 30 April 2021).
  • Horizontal bar charts (download v1.0)— Accepts up to six datasets for HORIZONTAL BAR CHARTS—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 9 June 2021).
  • Scatter plots (download v1.0)— Accepts up to five datasets for SCATTER PLOTS (updated 14 June 2021).
  • Pie charts (download v1.0)— Accepts a series of up to 36 items for PIE CHARTS (updated 25 March 2021).

See examples in Category:SVG diagrams created with spreadsheet.


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

Climate change — Own work ◣OW◢[edit]

Click at right to show/hide images

Alternative/renewable/green energy[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:

Blue copyright.svg
Cavannewcrest.jpg — Fair use image 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:

Blue copyright.svg





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 and images[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

Miscellaneous graphs, charts, flowcharts, maps[edit]

Hurricanes, ACLU donations, immigration, tobacco use by age, Trump statement veracity, relative income growth ...

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