Excel 2010 Line Graph issue 1

[Andrzejek]

Let's say I have some data like this:
[pre][blue]
2010 2011 2012 2013 2014
Bob 5 6 5 4 8
Susie 3 6 7 6 7
Clint 4 5 4 5 4
Ray 7 6 5 6 7
Tom 4 5 6 9 7[/blue]
Peter 8 3 7 5 8
Jan 6 5 4 9 8
[/pre]
If I select blue records and do: Insert - Charts - Line - first line icon - OK
I get the line graph with X - 2010, 2011, 2012, etc., Y - 0, 1, 2, 3, etc, and the legend on the side with Bob, Susie, etc. All is fine.

But if I select ALL records and do the same steps, I get a different line graph: X - Bob, Susie, etc., Y - 0, 1, 2, etc. and a legend on teh side with 2010, 2011, 2012, etc.

How can I get the line graph - like I get with just blue records - with all records?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[zelgar]

You can easily fix this. Select the Data Source and click the Swith Row/Column button.

 

[Andrzejek]

Yes, by: right-click on the chart, Select Data... - Switch Row/Column button

Thanks zelgar

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.