Forum Discussion
Conditional Format Bars and Line in a combo chart by year
Is there a way to format a combo chart to differentiate the bars and line conditionally based on the year? As you can see in the first screenshot, each year is a different color, and the average lin...
Hi MWC914 ,
It's not clear what you mean, if you want to highlight the specified data of the legend, you can click on it with the left mouse button. If the above results do not meet your expectations, you can express your expectations in the form of a picture, we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I meant if you could make the legend only display the value for the column, in this case Value1, and subsquently remove the individual line segments (2023year, 2024year, etc.). My data would be going back as far as 2015 and I would not want all 10 years showing up in the legend, just the column.