Graphing 2 sets of data

  • Thread starter Thread starter Troy T
  • Start date Start date
T

Troy T

Hello,

I am trying to Graph the following data on a single graph.

Amanda AB David A DA Nicole N NN Other O Total
12-Ju-03 34 47% 36 50% 0% 1 1% 72
13-Ju-03 60 45% 57 43% 17 13% 0% 134
14-Ju-03 45 34% 39 30% 45 34% 2 2% 132
15-Ju-03 34 22% 40 26% 78 51% 0% 152
16-Ju-03 31 66% 15 32% 0% 1 2% 47


The percentage number can be in any format (column, line etc) but the
standard number needs to be in column form.
Is this possible?
Thanks for your help.

Troy
 
Select all the data and plot in a column chart.

Select each of the % series (in turn) and (a) move it to the secondary
axis (Select Format | Selected Data Series... | Axis tab | select
Secondary) and (b) convert it to a line chart (it will still be the
selected object after a is complete, so just click Chart | Chart
Type...)
 
Back
Top