View source for Wikipedia talk:Graphs and charts

{{annual readership}}
{{User:ClueBot III/ArchiveThis
| age                 =2160
| archiveprefix       =Wikipedia talk:Graphs and charts/Archive
| numberstart         =1
| maxarchsize         =75000
| header              ={{Archive}}
| minkeepthreads      =5
| format              = %%i
}}{{Archives|bot=ClueBot III|age=90}}
<!-- Template:Setup cluebot archiving -->

== Misleading stacked vertical bar graph is generating for the correct data ==

Hi,

I believe there is some kind of issue/bug in the stacked vertical bar graph on Wikipedia. 

Refer to below data, I can confirm that all the values are in % & correct. All the values are summing up to 100%. Still not all stacks are reaching to 100%. See the stacks for 1999, 2004, 2009 & 2019 years in the chart. If you can't see them with naked eyes then Zoom-in the webpage, you will see the difference in the mentioned stacks.

<pre>
{{#invoke:Chart | bar-chart
| height = 360
| width = 850
| stack = 1
| group 1 = 43.11 : 34.86 : 27.42 : 26.6 : 38.96 : 19.73 : 40.42 : 63.84 : 29.37 : 16.13 : 2.69 : 1.57 : 6.7 : 15.68 : 16.48 : 2.78 : 0
| group 2 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 5.52 : 0 : 30.86 : 17.01 : 0 : 0 : 37.75 : 50.09 : 52.06 : 59.38
| group 3 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 13.08 : 7.86 : 22.58 : 14.08 : 22.83 : 37.83
| group 4 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 3.64 : 13.42 : 25.6 : 25.88 : 17.91 : 13.44 : 18.68 : 0
| group 5 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 57.34 : 11.0 : 59.83 : 2.23 : 0 : 0 : 0 : 0 : 0.14
| group 6 = 0 : 0 : 0 : 0 : 0 : 71.32 : 25.34 : 0 : 0 : 29.4 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 7 = 0 : 14.60 : 18.88 : 24.26 : 19.1 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 8 = 0 : 50.54 : 29.62 : 28.24 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 9 = 22.58 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 10 = 13.24 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 11 = 0 : 0 : 18.12 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 12 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0.57 : 0.47 : 0 : 1.74 : 0.43 : 0.36 : 0
| group 13 = 0 : 0 : 5.96 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 14 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0.5 : 0
| group 15 = 21.07 : 0 : 0 : 20.9 : 41.94 : 8.95 : 34.24 : 30.64 : 13.29 : 08.75 : 6.48 : 58.05 : 59.56 : 4.54 : 5.48 : 3.65 : 2.65
| colors = {{party colour|Indian National Congress}} : {{party color|Bharatiya Janata Party}} : {{party color|Samajwadi Party}} : {{party color|Bahujan Samaj Party}} : {{party color|Janata Dal}} : {{party color|Janata Party}} : yellow : {{party color|Praja Socialist Party}} : maroon : black : purple : brown : gold : {{party color|Aam Aadmi Party}} : Gray
| group names = [[Indian National Congress|INC]] : [[Bharatiya Janata Party|BJP]] : [[Samajwadi Party|SP]] : [[Bahujan Samaj Party|BSP]] : [[Janata Dal|JD]] : [[Janata Party|JP]] : [[Bharatiya Jana Sangh|ABJS]] : [[Praja Socialist Party|PSP]] : [[Socialist Party|SLP]] : [[Kisan Mazdoor Praja Party|KMPP]] : [[Communist Party of India|CPI]] : [[Communist Party of India (Marxist–Leninist) Liberation|CPI-ML]] : [[Akhil Bharat Hindu Mahasabha|ABHM]] : [[Aam Aadmi Party|AAP]] : Independents
| units suffix = %
| x legends = 1952 : 1957 : 1962 : 1967 : 1971 : 1977 : 1980 : 1984 : 1989 : 1991 : 1996 : 1998 : 1999 : 2004 : 2009 : 2014 : 2019 
}}</pre>

See the chart below- 

{{#invoke:Chart | bar-chart
| height = 360
| width = 850
| stack = 1
| group 1 = 43.11 : 34.86 : 27.42 : 26.6 : 38.96 : 19.73 : 40.42 : 63.84 : 29.37 : 16.13 : 2.69 : 1.57 : 6.7 : 15.68 : 16.48 : 2.78 : 0
| group 2 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 5.52 : 0 : 30.86 : 17.01 : 0 : 0 : 37.75 : 50.09 : 52.06 : 59.38
| group 3 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 13.08 : 7.86 : 22.58 : 14.08 : 22.83 : 37.83
| group 4 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 3.64 : 13.42 : 25.6 : 25.88 : 17.91 : 13.44 : 18.68 : 0
| group 5 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 57.34 : 11.0 : 59.83 : 2.23 : 0 : 0 : 0 : 0 : 0.14
| group 6 = 0 : 0 : 0 : 0 : 0 : 71.32 : 25.34 : 0 : 0 : 29.4 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 7 = 0 : 14.60 : 18.88 : 24.26 : 19.1 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 8 = 0 : 50.54 : 29.62 : 28.24 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 9 = 22.58 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 10 = 13.24 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 11 = 0 : 0 : 18.12 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 12 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0.57 : 0.47 : 0 : 1.74 : 0.43 : 0.36 : 0
| group 13 = 0 : 0 : 5.96 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0
| group 14 = 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0 : 0.5 : 0
| group 15 = 21.07 : 0 : 0 : 20.9 : 41.94 : 8.95 : 34.24 : 30.64 : 13.29 : 08.75 : 6.48 : 58.05 : 59.56 : 4.54 : 5.48 : 3.65 : 2.65
| colors = {{party colour|Indian National Congress}} : {{party color|Bharatiya Janata Party}} : {{party color|Samajwadi Party}} : {{party color|Bahujan Samaj Party}} : {{party color|Janata Dal}} : {{party color|Janata Party}} : yellow : {{party color|Praja Socialist Party}} : maroon : black : purple : brown : gold : {{party color|Aam Aadmi Party}} : Gray
| group names = [[Indian National Congress|INC]] : [[Bharatiya Janata Party|BJP]] : [[Samajwadi Party|SP]] : [[Bahujan Samaj Party|BSP]] : [[Janata Dal|JD]] : [[Janata Party|JP]] : [[Bharatiya Jana Sangh|ABJS]] : [[Praja Socialist Party|PSP]] : [[Socialist Party|SLP]] : [[Kisan Mazdoor Praja Party|KMPP]] : [[Communist Party of India|CPI]] : [[Communist Party of India (Marxist–Leninist) Liberation|CPI-ML]] : [[Akhil Bharat Hindu Mahasabha|ABHM]] : [[Aam Aadmi Party|AAP]] : Independents
| units suffix = %
| x legends = 1952 : 1957 : 1962 : 1967 : 1971 : 1977 : 1980 : 1984 : 1989 : 1991 : 1996 : 1998 : 1999 : 2004 : 2009 : 2014 : 2019 
}} [[User:PyneEditor|PyneEditor]] ([[User talk:PyneEditor|talk]]) 03:38, 26 April 2024 (UTC)

:It could be a typical computer problem, not a chart problem. For computers [[Binary_number#Fractions|decimal decimals are tricky things in a binary system]], which leads to [[Round-off_error]]s.
:One way to find out:
:* avoid decimals, multiply all your numbers by 100
:* does it now all add up to to 10,000?
:[[User:Uwappa|Uwappa]] ([[User talk:Uwappa|talk]]) 19:13, 3 November 2024 (UTC)
::This happens when summing fractions after rounding. A more extreme example is 160 categories, each accounting for 0.625% of the total. Rounded to 1%, their sum is 160%. In contrast, 80 categories of 1.25%, when rounded to 1% sum to only 80%. '''[[User:cmglee|cm&#610;&#671;ee]]'''&#9094;[[User_Talk:cmglee|&#964;a&#671;&#954;]] 01:47, 7 November 2024 (UTC)
:::There is no rounding error in the data of PyneEditor. 
:::This is probably a general computer problem, the binary way of dealing with decimals, converting them to {{fract|a|2}} + {{fract|b|4}} + {{fract|c|8}} + {{fract|d|16}} + ... where a, b, c, d, ... can only be 0 or 1.
:::* 0.5 is easy, that is {{fract|1|2}}. 0.5 in binary is 0.1.
:::* 0.6 is impossible, that is 0.100110011001... (with 1001 repeating).
:::[[User:Uwappa|Uwappa]] ([[User talk:Uwappa|talk]]) 03:54, 7 November 2024 (UTC)

== The Bar Box is not displayed on Wikipedia mobile app, but shown on web. ==

The 'bar box' are showing on Wikipedia Web, but not visible on Wikipedia mobile app. 

Any Specific reason? 

Shouldn't it be blocked at both places or allowed at both places? [[User:PyneEditor|PyneEditor]] ([[User talk:PyneEditor|talk]]) 03:48, 26 April 2024 (UTC)

== Progress? ==

I've got an idea for a tool that would need charting and I'm trying to figure out how to proceed.  I've read what's on phab and [[:mw:Extension talk:Graph/Plans]] and have come away with the impression that there's no concrete plan to implement this.  At least nothing with any kind of time estimate and thus I should be looking elsewhere for ways to implement the charting functionality.  Is that a fair summary of the state of things? [[User:RoySmith|RoySmith]] [[User Talk:RoySmith|(talk)]] 16:17, 3 November 2024 (UTC)

:You may want to contact [[user:Cmglee]] for a tailored graph. For me, working with Cmglee was an absolute blast, brilliant fellow, speaks fluent [[SVG]]. [[User:Uwappa|Uwappa]] ([[User talk:Uwappa|talk]]) 19:03, 3 November 2024 (UTC)
::Thanks for the compliment, but I won't have the time and resources to make graphs full-time.
::Until the Graph extension is operational, may I recommend generating graphs with [[GNU Octave]] (free software compatible with [[MATLAB]]), [http://stackoverflow.com/questions/67944131/octave-print-image-into-svg exporting in SVG format,] and uploading as standalone SVG files?
::Does anyone know of an offline tool that converts Graph extension format to SVG directly?
::Cheers, '''[[User:cmglee|cm&#610;&#671;ee]]'''&#9094;[[User_Talk:cmglee|&#964;a&#671;&#954;]] 17:16, 5 November 2024 (UTC)
:::* I don't know for Graph, but I do know it is possible to convert charts created with open office, [[LibreOffice]] to SVG: https://stackoverflow.com/questions/7485835/how-can-i-export-an-excel-openoffice-libreoffice-chart-to-svg 
:::* There are some [[Wikipedia:Graphs_and_charts#Creating_graphs_for_Wikipedia|alternative Wikitext based charts]] that do still work.
:::[[User:Uwappa|Uwappa]] ([[User talk:Uwappa|talk]]) 03:45, 7 November 2024 (UTC)
::I agree with the importance of supporting graphs and charts, especially for an encyclopedia. I don't know the WikiMedia tech stack, so I can only speak as a user. I see how GitHub handles this with Mermaid support in their pages, and that has been a boon for projects I work on there: It seems security concerns might be a non-issue with a restricted Mermaid execution environment, but needs developer work following this example. [[Special:Contributions/99.8.218.249|99.8.218.249]] ([[User talk:99.8.218.249|talk]]) 19:07, 6 February 2025 (UTC)

== Microsoft Excel spreadsheets that automatically generate XML code for SVG charts ==

My spreadsheets are not commercially viable products (they're totally text based), but they can quickly generate the basic SVG code for charts and are useful in many situations.
{{User:RCraig09/Excel to XML for SVG}} —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 00:45, 11 November 2024 (UTC)
:{{u|RCraig09}}. Thanks for your work. Can I use freeware Libreoffice Calc with these spreadsheets. I know Calc can read the .xlsx files:
:https://drive.google.com/drive/folders/1edEeBNX55Eh1a8hSmzfmX9w7tbMx2uOz
:But will using the files in Calc produce the desired result? 
:--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 13:39, 11 November 2024 (UTC)
:: {{reply|Timeshifter}} I don't know if the functionality of the Excel spreadsheet will translate. I remember that Excel's naming specific cells did not translate into Openoffice's spreadsheet, but I don't know if that exploded functionality. Since the spreadsheets have sample data already, you could simply download the specific spreadsheet(s) and see if they work in another spreadsheet program. —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 18:11, 11 November 2024 (UTC)
:::{{re|RCraig09}} I downloaded this file:
:::LINE SVG v3.2 20230909 from Excel.xlsx
:::I opened it in LibreOffice Calc. 
:::Copied the blue column to Notepad++
:::Changed extension to .svg
:::I opened it in Firefox, and I see a multi-line graph. 
:::It is not exactly the same as this:
:::[[:File:20200324 Global average temperature - NASA-GISS HadCrut NOAA Japan BerkeleyE.svg]]
:::Could you please install LibreOffice, and have a look yourself?:
:::https://www.libreoffice.org/download/download-libreoffice
:::I always install the latest stable version. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 21:47, 14 November 2024 (UTC)

:::: {{reply|Timeshifter}} I installed LibreOffice 24.8.3.2 and read the same Excel file. Visually, it renders exactly the same in Chrome 131.0.6778.86 as through Excel. I also get identical renderings in Firefox 128.4.0esr 64-bit. Is there a problem on your system? —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 05:14, 24 November 2024 (UTC)
:::: Oh, I see now! Wikimedia Commons [[File:20200324 Global average temperature - NASA-GISS HadCrut NOAA Japan BerkeleyE.svg|50px]] is an updated version over the Excel file that you downloaded. I manually made changes to the svg file after pasting from the spreadsheet so it would be more <s>presentable</s> current. They should not be the same. —05:19, 24 November 2024 updated —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 16:19, 24 November 2024 (UTC)

{{outdent|:::::}} {{u|RCraig09}}. Thanks. I don't have the time or expertise to experiment with your spreadsheets in LibreOffice Calc. But I want to use them. So maybe you can add an "Approved for LibreOffice Calc" to each spreadsheet you have tested. 

Also, which browser and OS you used. Does this matter? I ask, because it matters with the map template. It requires Firefox:
*[[Commons:File talk:Template map of US states and District of Columbia.svg/Instructions#Instruction summary. New map template]]
--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 08:17, 24 November 2024 (UTC)

:: {{reply|Timeshifter}} I will not be attempting the gargantuan task of stress-testing eight complex spreadsheets to be "approved" for other spreadsheet programs. I don't know of any browser- or OS-specific issues, but there are no guarantees. Separately, the "map" template you link above, is a completely different animal. —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 16:19, 24 November 2024 (UTC)
:::{{re|RCraig09}} I just want to know if a particular preset spreadsheet gets the same results in both Excel and Libreoffice Calc. I haven't paid for Excel, and so I can't do this. I assume that if it works with the preset values in the spreadsheet, then the spreadsheet will work with values I substitute. Calc can  read .xlsx files, and it can save in .xlsx, and so I am hoping this works. Because that allows more people to create these SVG files. 
:::I'll take whatever test results you have time to do. And I will help tell others about this. LibreOffice Calc is the most popular freeware spreadsheet program as far as I know. 
:::I am happy to hear that it is not browser or OS dependent. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 01:09, 25 November 2024 (UTC)
:::: {{reply|Timeshifter}} I don't know of any browser- or OS-specific issues; the only issues I can imagine would be if Calc somehow didn't understand a particular reference within the Excel sheet (like Excel's giving a particular cell a specific name). I haven't stress-tested in Calc, but the example we've talked about above is encouraging. Entering/pasting values into an xlsx file that's read into Libreoffice Calc (substituting for the "dummy" values that I've put into the xlsx files) and then pasting to an .svg file, will instantly let a person know if the SVG image results are basically as intended. Experimenting with dimensions, font size, grid lines, tick labels, etc. would be a Herculean task and I can't foresee my doing that since there has been little interest from others in using something that's text based and not a commercial-level product. —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 01:51, 25 November 2024 (UTC)
:::: I should add: there has been an ongoing problem within Wikimedia projects for some renderings involving text. It doesn't involve browsers or OSs. And my basic spreadsheets don't encounter those problems if you don't enhance the svg code manually, to insert bold or italic etc subsets of text strings. —<span style="font-family:Times New Roman;color:dark blue;">[[User:RCraig09|RCraig09]] ([[User talk:RCraig09|talk]])</span> 01:57, 25 November 2024 (UTC)

== Charts on mobile view not work properly ==

Hi, on mobile articles with charts are stuck and don't work as they should. This one for example:
https://en.wikipedia.org/wiki/List_of_Falcon_9_and_Falcon_Heavy_launches

You can view charts continuing to shift the entire article instead of being inside a box [[User:Briskola|Briskola]] ([[User talk:Briskola|talk]]) 08:32, 7 March 2025 (UTC)