+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Changing legend as per the Likert scale graph

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Changing legend as per the Likert scale graph

    Hi all

    I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.

    http://www.excelforum.com/excel-char...g-a-chart.html

    But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.

    Raja

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Changing legend as per the Likert scale graph

    Legend order is determined by series order.
    You can change series order via the format dialog. Although this may alter the layout of the chart depending on what you have setup.

    Post an example of your workbook so we can see the problem.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-26-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Changing legend as per the Likert scale graph

    Hi Andy

    Sorry for the late reply, was busy at work. I am attaching the demonstration here. The sheet 3 is the actual representation of the data, though the legends are all over the place and sheet 2 tries to put the legends in order, but I can't find a way of replicating the graph.

    Thanks for your help.

    Raja
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Changing legend as per the Likert scale graph

    If you change the plot order the legend will be correct but the data in the chart will be in the wrong place.

    So the simplest thing is to add 5 dummy series, with no values, just to provide the legend text.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-26-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Changing legend as per the Likert scale graph

    Thanks for your reply. I will give it a go. Raja

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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