Creating a line chart from a sales graph

Hi all,

Ive created a basic sheet which i've attached that we are using at work with some fun sales challenges.
what I would like to do is create 20 sheets which represent seperate weeks then have a line graph that grows as we fill in each week (so a 20 week line chart).
the line graph would have each persons name on the left side. the right side would be a percentage scale with the results from column E on each sheet being the actual lines.
If some could help me out with this would be great.

Not sure if this is exactly what you mean but it could be..

You need to use a 'summary sheet' to pull everything together for a chart.
In the attached I've got sheets for 2 weeks only (week 2 being week 1 with a couple of numbers changed).
In the real deal you'd have sheets and put in the formulas on the summary sheetfor all the weeks (called Chart).

Any use?

BSB

I think that’s what I’m after.
Thanks very much.
I’ll check it out tomorrow on my computer (too hard on the iPad).

Happy to help

Let me know if I completely missed the mark and we'll revisit.

BSB