Chart Legends
Chart Legends
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Chart Legends

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to change the legend entries around in my chart legend, how do I do that? Someone suggested this below, but I have no clue how to do it.

    "You can change the series order by editing the SERIES functions directly and changing the value of the last argument."

    Thanks for the help

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure that the extract you posted relates to the question you have asked.

    If I understand you correctly, you want to amend the legend on a graph?

    Click on the graph, then select from the menu bar Chart/Source Data. Now click on the "Series" tab.

    In the left hand box you will see "Series 1,2 etc" Select the one you want to alter and then type what you want to see in the "Name Box", or click on the red part of the Name box and select the data source that you want shown as the legend.

    Nobby

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-18 05:14, brad1 wrote:
    I need to change the legend entries around in my chart legend, how do I do that? Someone suggested this below, but I have no clue how to do it.

    "You can change the series order by editing the SERIES functions directly and changing the value of the last argument."

    Thanks for the help
    Suppose your charted the following data as a column chart...

    {"Fruit","Jan","Feb","Mar"
    ;"Apples",10,15,20
    ;"Oranges",20,30,40
    ;"Bananas",30,31,32}

    If you select the "Apples" column which is listed 1st in the legend you'll see a SERIES function like the following in the formula bar...

    =SERIES(Sheet1!$G$3,Sheet1!$H$2:$J$2,Sheet1!$H$3:$J$3,1)

    If you want to make "Apples" the last entry in the chart legend change it's last argument from 1 to 3 as follows...

    =SERIES(Sheet1!$G$3,Sheet1!$H$2:$J$2,Sheet1!$H$3:$J$3,3)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com