excel experts

nikork

I have a problem on my excel spreadsheet that I can't resolve. Can anyone help?

I am making a line graph. I have dates Jan-Feb along the bottom and scores 1-10 up the left. I want to enter multiple series showing what scores were given for each month. With me so far?

So when I enter just one series it come out great, with data points at the correct score/date. But, when I enter a second series of scores they are added on to the previous scores. So now my scores up the left go right up to say 16, if there was an 8 and an 8 on the same date for different series.

I can email the spready over if anyone want to help...

Thank you techy people, your colleagues need you!

cherrytree1

Hi Nikork
I'm v. new to this - is it possible to private msg me your spreadsheet? If so I'll take a look, I can't promise anything but will give it a shot as I'm a regular excel user!

simon.griggs

Dear Nikork,

If you want to send that file my was as well, if your other reply has not solved it yet, I am sure I can sort it for you.

Simon.