percentage/figs on the same graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chedd - 30 Oct 2007 15:40 GMT

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.

Reply to this Message

Barb Reinhardt - 31 Oct 2007 14:11 GMT

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.

Signature

HTH,
Barb Reinhardt

> 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
[quoted text clipped - 8 lines]
> Is there any way i can achieve the above without having to produce a seperate
> graph.

Reply to this Message