I need to draw a dispersion diagram in Excel, but that must be vertical, not horizontal.
I have this table and need to graph the "Weighted" column:
When I try, I get this horizontal graph:
What I need is a vertical graph like this that I can superimpose on my table:
I need the points on the graph aligned with the numbers on the left so I can produce a result Like this:
Does anybody know how I can do that?