+ Reply to Thread
Results 1 to 3 of 3

changing axis in line graph - label axis should be on y-axis

  1. #1
    Registered User
    Join Date
    03-24-2020
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    2

    changing axis in line graph - label axis should be on y-axis

    Hi, I have an issue I come across quite often. I built an evaluation tool for a personality type questionnaire and the profile at the end should show a line between the different aspects of personality. Thus I have 10 labels with 10 values to it. When I plot a line chart, excel will automatically put the labels on the x-axis and the values on the y-axis. However I would like to have the labels on the y-axis and the values on the x-axis. I tried playing around with it (not the first time), but seem not to be able to achieve what I want. I attached a picture of what I get and what I would like. In addition is it possible to mark an area in a different color on the graph (i.e. in this example I would like the area between 4 and 6 (average part) in grey.

    Thanks a lot in advance for your replies.

    Kind regards,
    Falimus

    chart.PNG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,034

    Re: changing axis in line graph - label axis should be on y-axis

    Create a "dot plot" -- which is basically a bar + scatter combination chart. Tutorial here: https://peltiertech.com/Excel/Charts/DotPlot.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-24-2020
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    2

    Re: changing axis in line graph - label axis should be on y-axis

    Super, thanks for your reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] X-axis of scatter chart: Tick mark and X-axis label for every data point
    By JayUSA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2018, 02:38 PM
  2. Changing X axis scale outwards from middle of graph via line
    By FHstudent in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-23-2014, 12:22 PM
  3. Changing X axis label range automatically and Create line for today
    By aaslezak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2013, 01:01 PM
  4. Replies: 1
    Last Post: 05-21-2009, 08:48 AM
  5. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  6. Concatenating a label on x axis on Line Graph
    By ChemistB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-04-2007, 04:51 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1