More Columns or Graph Multiple Rows Continuosly???

**TheRegime** · 03-01-2009, 06:51 PM

Ok so Im having the problem that I have reached the 256th column. I am doing a date on one row and a number on the row below. Now that Ive reached the 256th column Im forced to start a new row with a date and a row below it with my numbers.

So my question is. Can you go past the 256th column? If yes then how?

If no then is there a way to make a continuous graph from 2 sets of seperate rows.

For example from A1/A2 to IV1/IV2 then the graph continues on with A4/A5 to IV4/IV5

Row 1 being dates, row 2 being numbers, row 4 being dates, row 5 being numbers.

So that is makes a single continuous graph of numbers vs dates.

**shg** · 03-01-2009, 06:58 PM

No, you can't go past 256 columns except in Excel 2007.

Why not arrange the data vertically?

**TheRegime** · 03-01-2009, 07:03 PM

Originally Posted by shg

No, you can't go past 256 columns except in Excel 2007.

Why not arrange the data vertically?

I have 2007. It only lets me go to IV then there are no more columns.

Also vertically is a great Idea Ill try that.

How do I go past IV in 2007? Also what are the limitations on vertical in 07?

**shg** · 03-01-2009, 08:18 PM

I have 2007.

Then please change your profile to agree.

You're in compatibility mode. Save it as an xlsx or xlsm file, close, and reopen.

**TheRegime** · 03-01-2009, 11:11 PM

Originally Posted by shg

Then please change your profile to agree.

You're in compatibility mode. Save it as an xlsx or xlsm file, close, and reopen.

Sorry I had it as 2007 but didnt fill out something so it must of reset. Also thnx it was an old xlr file from 2003 excel. Ive changed it now. Thnx man.

**shg** · 03-02-2009, 06:24 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes