Chart Legends

[brad1]

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

 

[Nobby]

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

 

[Mark W.]

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)