Creating multiple charts
 

Hello, I sent out a request already but have another question. My main
worksheet is set up so the business sectors are listed in col A and all the
data is in col b-az. My questions, how can I turn this around so my business
sectors are in row 1 b-az
and the data is in col a rows 2-200?

Creating multiple charts
 

Select all the data: use Edit | Copy
move to destination: use Edit | Paste Special | Transpose
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MayJuneJuly" wrote in message
...
Hello, I sent out a request already but have another question. My main
worksheet is set up so the business sectors are listed in col A and all
the
data is in col b-az. My questions, how can I turn this around so my
business
sectors are in row 1 b-az
and the data is in col a rows 2-200?