Forum Discussion
Overlapping lines, change display order
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?
9 Replies
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.
Hi Anonymous ,
I'm not clear what's mean of "bring one line to the front and overlap the other".
If your have have 2 lines that mostly overlap, what about setting with different color to identify them like below?
Best Regards,
Cherry
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?
I might be mistaken, but I believe you can do this by re-ordering the source values in the Visualizations pane.
