Swapping X & Y Axis on worksheet: running out of columns!

[drgeoffrey]

I have an Excel worksheet that I am adding data to continually. When
the sheet was built, the new data was added column-by-column, a new
col for each day. The problem is, I keep running out of columns. Does
Excel allow more rows than columns? If so, is there any way to swap
all my data so that it will run in rows, and update the corresponding
graphs, without completely rebuilding the worksheet?
Any help would be great!
Adam

 

[Gary Miller]

You are posting on the wrong list, as this is a MS Access
list, HOWEVER, you need to be doing what you are doing in
Access from my estimation or, at the least, switch your row
as you are talking about.. In Access there would be ways to
manipulate the column names into data.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Debra Dalgleish]

To switch the data layout in Excel:
--Select the data, and choose Edit>Copy
--Select cell A1 on a blank worksheet
--Choose Edit>Paste Special, select Transpose, click OK

To create a dynamic chart that will automatically include new rows of
data, see instructions on Jon Peltier's web site:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html#DynoCht

To quickly rearrange your data for import to an Access table, you may be
able to use the technique described by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm