percentage/figs on the same graph
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200710/1

percentage/figs on the same graph
 

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.
--
HTH,
Barb Reinhardt



"chedd via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200710/1