Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: threaded When we put 'Show bars side by side' in a.xlsx file and close it, the option won't remember. It doesn't matter if we open the file again in Calc or Excel. This does not happen with .ods file in Calc, but does happen in Excel.
Created attachment 189253 [details] kopia.xlsx
Created attachment 189254 [details] kopia.ods
Created attachment 189255 [details] Data series options
Created attachment 189256 [details] Intended chart
Created attachment 189257 [details] Broken xlsx in Calc
Created attachment 189258 [details] Broken xlsx in Excel
Created attachment 189259 [details] ODS - Proper chart in Calc
Created attachment 189260 [details] ODS - Broken chart in Excel
Created attachment 189261 [details] Data series options (general view)
Is the option available in Excel?
The same result in: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: pl-PL (pl_PL.UTF-8); UI: en-US Flatpak Calc: threaded
(In reply to m.a.riosv from comment #10) > Is the option available in Excel? It look's like there is no similar option. I have never seen setting like this in Excel and as of my research there are only 'Series Overlap' and 'Gap Width' sliders in user interface: https://www.exceldashboardtemplates.com/stop-excel-from-overlapping-the-columns-when-moving-a-data-series-to-the-second-axis/ https://www.youtube.com/watch?v=Nja4FJ7gIEg https://www.youtube.com/watch?v=O73_ve-Lv5w https://www.google.com/search?q=how+to+separate+bars+in+excel+bar+chart&sca_esv=561558033&hl=pl&ei=WkHwZOP7E7_PwPAP57eryAs&ved=0ahUKEwjjkNKJsIaBAxW_JxAIHefbCrkQ4dUDCA4&uact=5&oq=how+to+separate+bars+in+excel+bar+chart&gs_lp=Egxnd3Mtd2l6LXNlcnAiJ2hvdyB0byBzZXBhcmF0ZSBiYXJzIGluIGV4Y2VsIGJhciBjaGFydDIHEAAYExiABDIIEAAYFhgeGBMyCBAAGBYYHhgTSOVZUIoMWM1YcAJ4AZABAJgBmQKgAfEdqgEGMzEuOC4xuAEDyAEA-AEBwgIKEAAYRxjWBBiwA8ICERAuGIAEGLEDGIMBGMcBGNEDwgILEAAYgAQYsQMYgwHCAgsQLhiDARixAxiKBcICDhAuGIAEGLEDGMcBGNEDwgIgEC4YgAQYsQMYgwEYxwEY0QMYlwUY3AQY3gQY4ATYAQHCAgsQLhiABBixAxiDAcICCxAAGIoFGLEDGIMBwgIXEC4YgAQYsQMYgwEYxwEYrwEYmAUYmQXCAgUQLhiABMICCBAAGIAEGLEDwgIFEAAYgATCAhQQLhiABBiXBRjcBBjeBBjgBNgBAcICCBAuGIAEGLEDwgIJEAAYDRgTGIAEwgIGEAAYFhge4gMEGAAgQYgGAZAGBLoGBggBEAEYFA&sclient=gws-wiz-serp https://www.google.com/search?q=how+to+set+chart+in+excel+not+to+overlap+bars&sca_esv=561558033&hl=pl&ei=KEHwZMS5MdWXjgb8066IBg&ved=0ahUKEwjE7YPyr4aBAxXVi8MKHfypC2EQ4dUDCGo&uact=5&oq=how+to+set+chart+in+excel+not+to+overlap+bars&gs_lp=Egxnd3Mtd2l6LXNlcnAiLWhvdyB0byBzZXQgY2hhcnQgaW4gZXhjZWwgbm90IHRvIG92ZXJsYXAgYmFyczIFECEYoAEyCBAhGBYYHhgdMggQIRgWGB4YHUjDkwFQpR1Y0ZEBcAZ4AZABAJgBeqABgxKqAQQxNS45uAEDyAEA-AEBwgIKEAAYRxjWBBiwA8ICCBAhGKABGMMEwgIFEAAYogTCAgQQIRgKwgIEECEYFeIDBBgAIEGIBgGQBgg&sclient=gws-wiz-serp
If the option, it's not in Excel, that explain the reason for what it is not saved in xlsx format.
(In reply to m.a.riosv from comment #13) > If the option, it's not in Excel, that explain the reason for what it is not > saved in xlsx format. Then what about providing information in the user interface, that this option is incompatible with .xlsx format in such kind of cases? This could save some/a lot of time of users struggling with this effect.
Created attachment 189289 [details] MS Office info icon by the options checkboxes with description I meant these kinds of additional informations.
Created attachment 189294 [details] Excel overlap spacing parameters.png Different approach to achieve a similar chart: adjusting overlap and spacing parameters.
Created attachment 189295 [details] Overlap,Spacing -100,200 & -100,400.ods
Created attachment 189296 [details] Calc can't assign different overlap,spacing parameters to different axis series.png It looks like Calc does not able to assign 'overlap', 'spacing' parameters separately to primary and secondary axis to XLSX file. In ODS everything works fine.
(In reply to Piotr Osada from comment #17) > Created attachment 189295 [details] > Overlap,Spacing -100,200 & -100,400.ods Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: threaded
Let's see if someone else with better acknowledge on charts, can help here.
(In reply to Piotr Osada from comment #18) > Created attachment 189296 [details] > Calc can't assign different overlap,spacing parameters to different axis > series.png > > It looks like Calc does not able to assign 'overlap', 'spacing' parameters > separately to primary and secondary axis to XLSX file. In ODS everything > works fine. From your attachment 189294 [details], I understand that MS Office is able to keep those overlap/spacing settings as they are when saving as XLSX? I can at least confirm the behaviour when saving as XLSX from LibreOffice: the two data series get the same Overlap/Spacing values. Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded And in previous versions, it would mess up the chart in various ways. The values were already reset to equal values between series back in 3.4.0rc1, and the current look started in 7.2.
(In reply to Stéphane Guillou (stragu) from comment #21) > From your attachment 189294 [details], I understand that MS Office is able > to keep those overlap/spacing settings as they are when saving as XLSX? Right, MS Office keeps those settings for both axes separately in XLSX.