Scatter chart with categories on x-Axis

Discussion in 'Excel Charting' started by Spi86, Feb 28, 2013.

  1. Spi86

    Spi86 Guest

    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


    --
    Spi86
     
    Spi86, Feb 28, 2013
    #1
    1. Advertisements

  2. Spi86

    Steve=True Guest

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


    --
    Steve=True
     
    Steve=True, Mar 1, 2013
    #2
    1. Advertisements

  3. Spi86

    Spi86 Guest

    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 Wrote:
    > 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


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


    --
    Spi86
     
    Spi86, Mar 1, 2013
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Don Culp

    Add 2nd Y axis in XY scatter chart?

    Don Culp, Jul 7, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    102
    Andy Pope
    Jul 7, 2004
  2. Jasmine

    X axis on XY scatter chart

    Jasmine, Aug 9, 2004, in forum: Excel Charting
    Replies:
    5
    Views:
    125
    Jon Peltier
    Aug 12, 2004
  3. squirrel_gurl
    Replies:
    1
    Views:
    121
    Tushar Mehta
    Oct 25, 2004
  4. HAF32
    Replies:
    2
    Views:
    77
    HAF32
    Feb 3, 2005
  5. SonzAMonz
    Replies:
    2
    Views:
    135
    Jon Peltier
    Jun 19, 2007
  6. -markc
    Replies:
    2
    Views:
    193
    -markc
    Oct 31, 2007
  7. Holger Gerths
    Replies:
    8
    Views:
    258
    Holger Gerths
    Jun 5, 2008
  8. rmellison
    Replies:
    3
    Views:
    112
    Jon Peltier
    Apr 15, 2009
Loading...