Created attachment 172116 [details] Example file from Excel Attached user-made file contains a simple 3D column chart with one data series. The columns in the column chart are colored with a different gradient for each, except for the last orange bar which is solid color. The legend in Excel shows all the data points with their individual colors, while in Calc it shows only the data series name. Setting back in Excel the individual data point colors also shows the data series name instead of the data points. Or turning on-off the Vary colors by data points setting, which does not seem to be enabled by default, yet the different coloring seems to have the same effect on the legend. Steps to reproduce: 1. Open attached file Actual results: Legend displays only the data series name. Expected results: Legend displays the individually colored data points labels. This currently does not seem to happen in Calc for new charts either. LibreOffice details: Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 91330c503b7eb91d777978018b66890af87cf8f5 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also in 7.0, 6.0, 5.0, 4.0
Created attachment 172117 [details] Screenshot of the original document side by side in Excel and Calc
Reproducible. Version: 7.1.3.2 / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: CL
Reproduced in Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 8771f48512ed19197c17506f522578f43b092b21 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Still the case in: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a81e957f5026373f3935390c786c21416fc74fcc CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded