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.
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