Scatter chart with categories on x-Axis

[Spi86]

Hello

I want to make a chart in Excel that plots values on the y-axis to th
specific category. The category is plotted on the x-axis. See exampl
here: http://www10.pic-upload.de/28.02.13/wuag2tpidf53.jp

I am almost sure that excel can do that, since it can everything :

Thanks a lot for your hel

 

[Steve=True]

Hi SPi86,

Welcome to the forums.

Of course you can do this

Set up your data like the picture.

Then create a line chart with markers, not an XY chart.

Then Switch the Rows/Columns from the Design Ribbon.

Let me know if this works for you.

Steve=Tru

+-------------------------------------------------------------------
|Filename: LineScatterChart.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=792
+-------------------------------------------------------------------

 

[Spi86]

Hey,
Thanks for your reply. I can reproduce your diagram, and it is an almos
ok solution for my problem

The problem with your solution is that I have to rearrange my data. (
get the data the way I showed it in the picture.) And to rearrange th
data I would like to avoid.

Another ok, but not perfect thing about your solution is that I have t
change the symbols by hand. I forgot to say that in the beginning, but
would like to have for each category A, B, C a unique symbol. With tha
I mean over category A is symbol 1, over category B is symbol 2 ...

Do you know how to do that?

Thanks again for your help

Hi SPi86,

Welcome to the forums.

Of course you can do this

Set up your data like the picture.

Then create a line chart with markers, not an XY chart.

Then Switch the Rows/Columns from the Design Ribbon.

Let me know if this works for you.

Steve=Tru

+-------------------------------------------------------------------
+-------------------------------------------------------------------