percentage/figs on the same graph

[chedd via OfficeKB.com]

I am trying to produce a chart showing monthly number of referrals for 4
people and with another column showing percentages. The chart i have chosen
is column with a line to show the percentage fig.

The first column (A) has there names. Column B has there monthly totals and
column C has the percentage figs. All 3 colums represent 1 month and i done
the same for a whole year.

The issue i am not able to show the percentage fig in the line graph.

Is there any way i can achieve the above without having to produce a seperate
graph.

 

[Barb Reinhardt]

Go ahead and add a series for the Percentage
Double click on the data series to format the data series and select the
axis tab. Select secondary axis.