Created attachment 175353 [details] Example file from Excel Attached example file was made in Excel and contains charts with multiple categories. The charts on the right have an automatic label rotation, which means the roman quarter labels and the years are horizontal in Excel. In Calc however if the data range is only partially covering the primary category with secondary data points, i.e. there is only one secondary data point for the last “2009” item in the data range, the labels are rotated. This does not happen if the data range fully covers the primary data point, even if there are no actual values filled in. Steps to reproduce: 1. Open attached document in Excel and Calc Actual results: The quarter labels are rotated 270 degrees on the “Axis rotation: empty” titled charts: a combined bar+line chart on top and a bar chart at the bottom. This does not happen for the right side charts that differ only in the size of the data range. Expected results: The quarter labels of the secondary data series are not rotated in any case. LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b60b6bfaafa1315e07108dba50f016975b619c59 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also in 7.0, 6.0 - 5.4 (although these rotated the years too), 5.3 and before did not show the secondary labels at all for these charts.
Created attachment 175354 [details] Screenshot of the original document side by side in Excel and Calc
Reproduced in Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: ea65215855462e5e48f7a3a78724c38b5fc0e4d1 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded