Graphing 2 sets of data

T

Troy T

Hello,

I am having trouble graphing normal numbers and percentages on one
graph. The data is collected by date and a persons name:

Person 1 P1% Person 2 P2% Person 3 P3% Person 4 P4%
Total
7-Jul 10 12% 27 33% 0 0% 44 54%
81
8-Jul 31 32% 19 20% 26 27% 20 21%
96
9-Jul 56 43% 14 11% 36 28% 23 18%
129


The graph type is not really relevant.
If someone can help I would be very appreciative.

Thanks,

Troy.
 
D

dvt

Troy said:
Hello,

I am having trouble graphing normal numbers and percentages on one
graph. The data is collected by date and a persons name:

Person 1 P1% Person 2 P2% Person 3 P3% Person 4 P4%
Total
7-Jul 10 12% 27 33% 0 0% 44 54%
81
8-Jul 31 32% 19 20% 26 27% 20 21%
96
9-Jul 56 43% 14 11% 36 28% 23 18%
129


The graph type is not really relevant.
If someone can help I would be very appreciative.

I don't know what you're trying to chart. Can you tell us what the x- and
y-axes are supposed to be?

You might find that a secondary y-axis is helpful. Excel's help will show
you how to do that. I'd give you instructions, but I don't know enough
about your desired chart just yet.

Dave
dvt at psu dot edu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top