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?

  • Your question isn't clear now. Please explain how the graph should look like and what is the logic behind axis numbers. – Máté Juhász Nov 14 '15 at 19:20
  • The Y axis appears to be a category list with numerical names. The X axis is non-linear. It will be difficult for anybody to answer without more information about the data. – fixer1234 Nov 14 '15 at 19:34
  • 1) What is the scale of the X axis (it's non-linear)? I don't believe you can do that natively in Excel. Do you need that in your graph or can you use a linear scale? 2) You have some values that appear to be in random (maybe chronological) order, and you're connecting sequential values with a line. Is this supposed to illustrate some sort of progression over time? – fixer1234 Nov 14 '15 at 23:05
  • The values are from a subjective evaluation. importance is evaluated from 1 to 5, impact is from -3 to 3 and Wighted is importance*impact. this is the graph i obtained [link] (dropbox.com/s/31d4sxq6k05wxfx/Obtained.PNG?dl=0) (sorry for the link, can´t put in the question). I need to obtain somethin like this [link] (dropbox.com/s/lozj1rvdnulw0t8/try.PNG?dl=0) but my problem is that i can´t put the graphic – Lena Von Engel Nov 14 '15 at 23:26

To get something like this:
enter image description here
you do not need to do pretty much.

As i can see, you allready have the chart.
To line it up, you only need a transparent background:
Rightclick your chart and Format it.
enter image description hereenter image description here
(after the hight is as you wanted it, you can do a solid fill again if you like)

For getting the "Limit"-lines you can use a simple trick. Create a small table like the grey one on the right with one empty row (wherever you want). Add a second graph (should be 2 lines) and then simply format them.
enter image description here

However, to make excel lining up a chart with your cells is as good impossible.

Hopefully that helped at least a bit.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.