Vertical Scatter Graph

[claes1koen]

I have following date:

Knipsela.PNG

And I need them to get in a scatter graph, but with only on the vertical line the prices, and on the horiontal line the brands, with each a vertical "line of dots" with the different prices that that brand offers.

Can someone please help me?


Thanks !

[MrShorty]

I'm not sure I understand what you are looking for.

Why scatter graph and not line graph? With a category X axis, it seems to me that a line chart will more easily accomplish what you are looking for. My first attempt would be to select the table (A1:L32) and insert a line chart. Make sure Excel correctly interpreted the data series in rows (execute rows to columns if it did not). Then format as desired.

If you decide that a scatter chart is a better choice, you can adapt this vertical category axis so that it applies to the horizontal axis: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html