:User:RCraig09/Excel to XML for SVG

File:20210601 Spreadsheet automatically generates XML code for SVG graphics - flow chart.svg

{{multiple image | align = right | direction = horizontal | total_width = 400px

| image1 = 20210502 Warming stripes comparison of Global Mean Surface Temperature datasets.svg | caption1 = Warming stripes
(five examples compared)

| image2 = 20210522 Warming stripes - longitudes - meridians on a globe - global warming.svg | caption2 = ... in a shape

| image3 = 20210822 Global warming - warming stripes bar chart.svg | caption3 = Warming stripes bar chart

}}

{{multiple image | align = right | direction = horizontal | total_width = 400px

| image4 = 2020+ Electric vehicle stock - International Energy Agency.svg | caption4 = Bar chart

| image5 = 1994- Earth's ice imbalance - ice loss - Climate change - Global warming.svg | caption5 = Pie chart

| image6 = 20210703 Variwide chart of greenhouse gas emissions per capita by country (includes OTHER).svg | caption6 = Variable-width bar chart

}}

{{multiple image | align = right | direction = horizontal | total_width = 400px

| image7 = 20200324 Global average temperature - NASA-GISS HadCrut NOAA Japan BerkeleyE.svg | caption7 = Line charts

| image8 = 20230604 Gun death rates related to household gun ownership rates - by state - US.svg | caption8 = Scatterplot

| image9 = 1980- Arctic sea ice volume - radar chart by decade.svg | caption9= Radar chart

}}

I've uploaded spreadsheets that automatically generate XML code for charts in SVG format.

Summary: You simply paste or enter your data into the spreadsheet, and specify image dimensions, number of grid lines, data ranges, font sizes, etc. The spreadsheets instantly and automatically generate a column of XML code. You simply copy and paste that code into a text editor and save as an ".svg" file. The spreadsheets produce lean SVG code, and should save you time in creating SVG charts. Though my original spreadsheets are written in Microsoft Excel, I've received reports that they also work if read into other spreadsheet programs.

Feedback and suggestions on my talk page are welcome. RCraig09 ({{int:Talkpagelinktext}}) 23:41, 19 February 2021 (UTC)

1. {{red|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. {{red|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. {{red|Line charts}} — Accepts up to six datasets. (updated 30 August 2023)
4. {{red|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. {{red|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. {{red|Scatter plots}} — Accepts up to five datasets. (updated 28 August 2023)
7. {{red|Pie charts}} — Accepts a single dataset of up to 36 items. (updated 17 May 2023)
8. {{red|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)
9. {{red|Radar charts}} — Accepts up to six datasets. (updated 6 May 2025)

{{clear}}