Creating multiple charts

M

MayJuneJuly

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?
 
B

Bernard Liengme

Select all the data: use Edit | Copy
move to destination: use Edit | Paste Special | Transpose
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NFL spreadsheet 3
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
Formating bolded text exclusively. 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Aligning an excel table w/ a cluster column chart x-axis columns 2
Embed the same Excel multiple times 0
Change Chart Properties for Multiple Chart Shts using a Worksheet 0
Drop down list control value in vba 2

Top