Ask Mac Questions and Get Answers from Experts ASAP
I will be happy to switch the axis for you and show you how it's done if you can send me the file. Do you have the file available that you could upload?
Sure, go to www.wikisend.com and upload the file there. You will then get a page that has the File ID and Download Link. Copy either the File ID or the Download Link and come back here and paste it in your reply.
I don't see an existing chart to switch the axes of, not do I see names in column A.
Which specific columns (x and y) need to be plotted. Maybe you need to rephrase the original question so it applies to the file that you sent me
Sorry had to step out for a while
Ok here you go
I have converted the first 12 columns of Sheet1 (i.e. columns A thru L) into rows on Sheet2 (rows 1 thru 12). If you need me to do the rest of the columns please let me know
Hope this is ok. Please feel free to reply if you need further clarification or click Accept if this answers your question fully.
Glad this was what you wanted
Ok you are going to have to do it one column at time. If that's ok I will show you how you can do that in a few steps
Ok, here is a neat way to copy columns into rows (or vise versa)
1- select the range that you want to copy in that column (e.g. A1:A23), and copy it
2- select the first cell in the row that you want to paste it in horizontally
3- from the Edit menu select Paste Special
4- In the Paste Special dialog box, check the box next to Transpose and click OK
Voila!, data pasted.
Hope this helps. Please feel free to reply if you need further clarification or click Accept if this answers your question (that is the only way I get credit for helping)