File:20241229 Using concatenate function in spreadsheet to create SVG code - demo.svg

From testwiki
Jump to navigation Jump to search
    Original file (SVG file, nominally 1,800 × 750 pixels, file size: 4 KB)

    This file is from Wikimedia Commons and may be used by other projects. The description on its file description page there is shown below.

    Summary

    Description
    English: Diagram demonstrating how to use a spreadsheet's concatenate function to automatically generate SVG code
    Translate this file This SVG file contains embedded text that can be translated into your language, using any capable SVG editor, text editor or the SVG Translate tool. For more information see: About translating SVG files.
    Date
    Source Own work
    Author RCraig09

    Transcluded description:

    General concept above; examples below.
    Warming stripes
    Warming stripes bar chart
    Waffle chart
    Bar chart
    Pie chart
    Variable-width bar chart
    Line charts
    Scatterplot
    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 (talk) 23:41, 19 February 2021 (UTC)

    Click HOW TO for detailed explanation.
    Click HERE (else HERE) to download the spreadsheets.
    Click here to see an example of how the spreadsheets work, internally.
    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 14 September 2026)
    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 14 September 2026)
    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 14 May 2026)
    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 28 December 2025)
    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)
    9. Radar charts — Accepts up to six datasets. (updated 6 May 2025)
    10. Waffle charts (dot matrix charts) — Creates up to 32x32 array of squares, rounded-corner squares, circles, or stars, each filled with one of up to 26 user-chosen colors, and optional textual labels for each box. (updated 17 June 2026)

    Licensing

    I, the copyright holder of this work, hereby publish it under the following license:
    w:en:Creative Commons
    attribution share alike
    This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International license.
    You are free:
    • to share – to copy, distribute and transmit the work
    • to remix – to adapt the work
    Under the following conditions:
    • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
    • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.

    Captions

    Diagram demonstrating how to use a spreadsheet's concatenate function to automatically generate SVG code

    Items portrayed in this file

    depicts

    29 December 2024

    image/svg+xml

    3,816 byte

    3dac4ed0927178091309daf32630f21ae24b96b6

    File history

    Click on a date/time to view the file as it appeared at that time.

    Date/TimeThumbnailDimensionsUserComment
    current07:46, 30 December 2024Thumbnail for version as of 07:46, 30 December 20241,800 × 750 (4 KB)wikimediacommons>RCraig09Version 4: change line 6 to consistently be code and not displayed numerical values

    There are no pages that use this file.