Scatter chart with categories on x-Axis

S

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
+-------------------------------------------------------------------
 
S

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




Steve=True;1609918 said:
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top