Forum Discussion
Combo Chart with Line Issue
Hi DPCCGF ,
Thank you for your kind reply!
When you add Year to the legend of a line and cluster bar chart instead of the x-axis, the line chart shows the average total for all years and all teams (16%). This is because the chart treats “Year” as a categorical variable rather than a numeric variable. Therefore, it aggregates the data for all years and calculates the average.
You could try the methods below to solve the problem.
1. Add “Year” to the X-axis: Make sure that “Year” is added to the X-axis and not to the legend. This way, the chart will treat the year as a numeric variable and display the data points for each year on the X-axis.
You could set your own colors to better differentiate between Years.
2. Add “Team” to Legend: Add “Team” to the legend so that each team's data will have a different color or style for easy differentiation.
Please let me know if I've misunderstood anything.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lucy, these look great. I need to crunch these down a bit width wise. I have to live with a 375 width as they place these into an annual report. So I had something like the below but each of those lines is a single chart overlayed on the bar chart. Is there a way in your charts to leave them as is but hide that year so I can reduce the width. Then I could make a year legend and work the colors that way?
Hi DPCCGF ,
Could you please tell me in more detail what you are trying to achieve, I don't think there is anything particularly wrong with the screenshots you have provided, and what do you expect the final result to look like?
Thank you for your understanding!
Best regards,
Lucy Chen