On a Line and Clustered Column Chart, I have 2 lines that mostly overlap. I want to bring one line to the front and overlap the other. I've tried to change the ordering in the 'Line Values' section but it does not change.
How do I change the overlapping order of lines on a Line and Clustered Column Chart?
Thank you for your response, I thought I posted this image earlier.
Here is an example of the chart I am working with. I want the red line to be more prominant than the yellow line.I want the red line to overlap the yellow line. I dont really want to change the line weight or shape of the line. Is it possible to make that change?
Huh. When I swap them, they swap colors and which one shows up better on top.
You may be able to go into Shapes>Customize Series ON> turn the line style of your yellow line to dashed or dotted to emphasize it's less important then. Or increase the stroke width of the red line by 1. It's not a lot, but it will make it pop.
I had the same problem and found a hack solution (I googled and found your post, then played with a few things). The order of overlap depends on the order you drag measures into the 'Values' section of the visualisation.
Drag everything out to the 'Tooltips' section just beneath it, then drag them back into 'Values' in the order you want, back to front.