Tennis Players sample data

[freeda910]

This is number of aces served by players in every match in a Tennis tournament League.

Player	Match1	Match2	Match3	Match4	Match5	Match6	Match7	Match8	Match9	Match10
Alex	22	30	20	10	22	60	10	20	30	10
Bob	30	40	60	50	70	20	30	20	30	45
Clement	30	40	20	45	30	60	20	16	18	21
David	20	16	18	20	16	25	30	19	25	39
Edward	50	16	17	36	16	19	20	45	20	30
Francis	60	17	28	19	60	30	20	30	16	11

<tbody>
</tbody>

I am sending a sample picture.
https://app.box.com/s/eeh5454lfomxwc92dvvy
https://app.box.com/s/trtpep8u9nibnxlqzfl2

I want to plot Chart in column L (size is not a problem)
Alex aces chart should be displayed in L2
Bob's aces chart should be displayed in L3 and so on.

How do I do that?

Thanks in advance,

 

[freeda910]

can somebody help me

 

[wymanlee]

Hi,

are you using excel 2010 ? look for Sparkline mini charts in your tabs.

regards,
Wyman

 

[freeda910]

Wyman lee. thank you.
i am using Excel 2007
Where can i find the sparline mini chart in 2007
Freeda

 

[wymanlee]

Hi Freeda,

Sparkline is not a default addon for excels 2007. It's made available in excel 2010.

If you would like to have spark lines for 2007, then you might need to work in manually. I used to do it referring to one of the site's tutorial.
How to Make Sparklines in Excel 2007 | Katherine S. Rowell

Alternatively, y not lump all data into one line chart? use the available resources hassle free

Regards,
Wyman

 

[freeda910]

Thank you WymanLee.
That website really superb.