Scatter chart with categories on x-Axis

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

  1. Spi86

    Spi86 Guest


    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

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

    Thanks a lot for your hel
    Spi86, Feb 28, 2013
    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.


    |Filename: LineScatterChart.jpg
    Steve=True, Mar 1, 2013
    1. Advertisements

  3. Spi86

    Spi86 Guest

    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

    Spi86, Mar 1, 2013
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.