To increase visibility of data markers (referred to as "Icons") for a data series on a line graph, it would be great to be able to set separate Color and Transparency values for Icons. Since some icons can be complex graphics, the behavior would be beneficial at least for the predefined monochrome Symbols type. For instance, a yellow icon on a green line stands out visually better than green on green.
Symbols are just one option, you can also use the Gallery/bullets images or load a graphic from file. What I mean (besides simplicity) is that your envisioned option "Icon Color" would be available in one condition only.
Created attachment 175388 [details] Screenshot Points in a line chart receive a symbol by default.
(Tangential note: Yep, that option should be renamed; I can do it.)
It would be beyond the scope of my intent to assume that one could colorize rasterized images such as gallery/gullet images as you call out. Being heavily vectorized in nature, I would imagine that vectorized bullets capable of relatively easy colorization would be preferred. What I mean to say is that while it may only be "one condition," it is likely the most common condition.
It depends on whether this attribute is defined in the format and if other formats/applications allow changing the color; in this case we need it for proper round-trips. ODF1.2 states: "The fill attributes of the series and data points specify how the symbols are filled. By default the symbols are filled solid with the same color as the connecting line. In case no line color is given but a fill color, the line uses the fill color." This makes the request a WF. But I might be wrong (Regina, am I?) and wonder if Excel can format the symbols separately. If so, please reopen and attach an example file.
Created attachment 175573 [details] Line graph showing separate formatting for lines and markers This is possible today using Excel. Shown is version 2016, but this functionality has been around for a long time.
Created attachment 175574 [details] Excel's Line Formatting dialog This shows various options specifically for line formatting, separate from marker formatting. The configuration is distinct from the other.
Created attachment 175575 [details] Excel's Marker Formatting dialog This shows various options specifically for marker formatting, separate from line formatting. The configuration is distinct from the other.
(In reply to Concerned User from comment #6) > This is possible today using Excel. Thanks for checking. And consequently we need it for round-trip compatibility, at least. Could you please share a sample from Excel with a line having a color different to the markers, saved in XLSX?
Created attachment 175579 [details] Sample .XLSX file showing various formatting I created a simple table with 3 series with 3 data points each. Each series has different line and marker formatting to showcase some of the formatting capabilities in Excel. Notice all formatting is depicted in both the graph area as well as the legend. ================================================== Series "One" Line Line type: Automatic (preset values for all variables) Color: "Blue, Accent 1" Transparency: 0% Width: 2.25 pt Compound type: Simple Dash type: Solid Cap type: Round Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked Marker Marker Options: + Built-in + Type: Square + Size: 10 Fill: + Solid Fill + Color: "Red" + Transparency: 0% Border Type: Solid line Color: Red Transparency: 0% Width: 0.75 pt Compound type: Simple Dash type: Solid Cap type: Flat Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked ================================================== Series "Two" Line Line type: Gradient line Type: Linear Angle: 270° Gradient Stop 1: + Color: rgb(171,129,0) + Position: 0% + Transparency: 0% + Brightness: -33% Gradient Stop 2: + Color: rgb(255,194,8) + Position: 60% + Transparency: 0% + Brightness: 3% Gradient Stop 3: + Color: rgb(171,129,0) + Position: 100% + Transparency: 0% + Brightness: 40% Width: 2.25 pt Compound type: Simple Dash type: Solid Cap type: Round Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked Marker Marker Options: + Built-in + Type: Diamond + Size: 20 Fill: + Solid Fill + Color: "Red" + Transparency: 0% Border Type: Solid line Color: Red Transparency: 0% Width: 0.75 pt Compound type: Simple Dash type: Solid Cap type: Flat Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked ================================================== Series "Three" Line Line type: Automatic (preset values for all variables) Color: "Gray-50%, Accent 3" Transparency: 0% Width: 2.25 pt Compound type: Simple Dash type: Solid Cap type: Round Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked Marker Marker Options: + Built-in + Type: Triangle + Size: 10 Fill: + Solid Fill + Color: "Green" + Transparency: 0% Border: Solid line Color: "Purple" Transparency: 0% Width: 2 pt Compound type: Simple Dash type: Solid Cap type: Flat Join type: Round Begin Arrow type: No Arrow Begin Arrow size: Arrow L Size 5 End Arrow type: No Arrow End Arrow size: Arrow R Size 5 Smoothed line: Unchecked
Created attachment 175580 [details] Render of sample Excel file at 100% zoom
It's clear that Excel has a significant amount of additional formatting options for data series, and attempts to implement every single one of these features would be very time consuming. If only one of these additional features were to be prioritized, it is my opinion that being able to separately colorize markers with a solid fill distinct from the formatting of the line itself would be most desirable.
This behavior persists in the latest release (7.2.2.2).