Marlese_fairgra's avatar
Marlese_fairgra
New Member
5 years ago
Status:
Needs Votes

Diagonal lines

Hi I'd like to be able to add multiple diagonal lines to a scatter plot, similar to the symmetry, horizontal and vertical lines with set gradients. ie. x=y - symmetry axis, x=2y, x=3y etc.. At present, using a line shape takes some time to get it in the approximate position, its not accurate and position becomes redundant if you move or resize the visual. Cheers

3 Comments

  • A reasonably valuable use case for this functionality is for portfolio management. Using a scatterplot, 3 dimensions (x, y, bubble size) and color can be used to clearly, visually indicate which projects are highest value and move the needle the most, in an easy to understand manner. But what is often needed is also a cutoff line, a line that crosses both axes diagonally. Projects above/to the right of the line are worked, and projects to the left and below the line do not have enough added value, urgency, ROI, or whatever criteria is being used to evaluate the projectsin 2 dimensions, to be worked.


    With the diagonal line, we can condense information that make take pages and pages to share in a different format, into a single, easy to understand one-page format that facilitates 15 minute reviews with C-level stakeholders, vs. hours of sometimes strained conversation to explain the portfolio status, approach and next steps.


    As mentioned by Marlese, it is possible to place a static line and rotate, but that can be an endless chore of updates as the project list changes.

  • I have another use case. I have a scatter chart for actual versus predicted values. The users are not interested in showing the trend line, but they do want a diagonal line thru center (x = y) - I was not able to create the line, but at least I was able to use the Symmetry Shading option under the Analytics tab. However, they also need error band mean lines, which is basically the standard deviation calculation. For example, if the standard deviation of the selected data is 105, they would like to see diagonal lines at 105 intervals on each side of x=y (up to 3 sets). The equation for the first set of lines would be y = x + 105 and y = x - 105, the equation for the 2nd set of lines would be y = x +210 and y = x - 210, and for the 3rd set y = x +315 and y = x - 315. I tried doing a screen shot, but it will not let me paste it from my clipboard.

Recent ideas