Multiple Legends in single chart.

[jsk_lge]

hi there,

i want to use more than one (two) legends in my single chart.
how can I do so ??

sample data is below:

Region EMP Count Investment Cost

East 14 2.5%
West 10 1.9%
North 17 1.6%
South 24 2.1%



Thanks in advance.

 

[Hui]

What type of chart ?
What do you want to see in the each legend?

What about using Series Labels to identify the data?

 

[jsk_lge]

Dear Sir,
in the attached file,
i want to show EMP count as column series while in same chart, i want to show primary & secondary as row series, but is not possible with a single legend.
so i want separate legends for column & row series.
pls help.



thanks.

 

[Hui]

Do you mean like this ?


or

 

[Hui]

or maybe with labels:

 

[Hui]

If these aren't correct can you sketch a picture of what you need?

 

[jsk_lge]

Dear HUI,
sorry for delay,

I want a chart something like in attached sheet.
pls suggest how to make it ?

 

[Hui]

like this ?

 

[jsk_lge]

yes !!!
but how I can ??

 

[Hui]

Select Range A1:D6
Insert, Chart, Column, Clustered Column
Use Up/Down arrows until the Primary Data is selected
Ctrl+1
Secondary Axis
Use Up/Down arrows until the Secondary Data is selected
Ctrl+1
Secondary Axis
It should look like this:


Right Click on the Primary and Secondary Columns in Turn
Change Series Chart Type
Select Line for each
It should now look like:



Select Each line in turn
Right Click
Format Data Series
Line Color
Set as required

Right Click on Each Line
Add Data Labels

Click on the chart
Right Click on each Data label
Format Data label
Set the Label Options to Centre
Set the Fill colors as appropriate



Enjoy

See attached file in the next post:

 

[Hui]

see attached file:

 

[jsk_lge]

Thank you very much Hui sir.