Excel???

[timbo]

Is there a maximum number of columns available for use in Excel?

[HeSaidJoe]

this is only a guess but I would say over 6000
More than you could possibly use with any degree of sanity.

[timbo]

I only seem to be able to have a maximum of 256 columns. It is funny that you mentioned 6000 as that is the number that I require.

[JHausmann]

According to help:

Maximum worksheet size 65,536 rows by 256 columns

[JHausmann]

Originally posted by timbo
I only seem to be able to have a maximum of 256 columns. It is funny that you mentioned 6000 as that is the number that I require.

Just out of curiousity, what is it you're doing that would require 6000 columns?

[timbo]

I'm calculating a differential equation with time steps of 0.01 seconds over 60 seconds. These values are in an array and I need to display them on a graph as a single line. I cannot get MSChart to work so I am trying put the values into Excel and then display them.

If you have any suggestions I would be very grateful.

Thanks.

[JHausmann]

How many rows do you currently have (can you swap rows for columns in your current scheme)?

[HeSaidJoe]

everything = 256

Guess I did the math wrong
There are 26 letters a to z and 26 variances for each of the letters used.

A to z = 26
aa to az = 26
ba to bz = 26
etc.
Where I screwed up was I used the whole alph + 9.6
when I should have used 9.6 as it doesn't use the whole
alph, it only goes to iV.

Sorry, for my ______ !

[timbo]

I tried that but it seems to print out x number of individual lines rather than one line with x number of points on it.

[JHausmann]

Using the chart wizard, select "Series in" to be column instead of rows.

Or, right click on the chart, select source data, and make sure the column button is checked

[Edited by JHausmann on 08-28-2000 at 07:10 PM]

[timbo]

This'll seem a stupid question but where do I find chart wizard!

[JHausmann]

Either select "Chart" from the insert menu or pick the pretty chart button on the toolbar (right next to sort descending).

[timbo]

Embarressingly enough, I still can't find it!

[JHausmann]

It's on the "standard" toolbar, check to see that you have it enabled. Counting from 1, it's the 19th item in the Excel 97 tool bar ( a small bar chart, with blue, yellow and red bars [yellow being the highest])

[timbo]

That explains it - I was looking at the VB toolbar!

I have a VB program that works out the values and it puts them into Excel. How then can I import the graph produced back into VB?

Thanks again.

[JHausmann]

Make the chart (after you've populated the column) in Excel with "macro" recording active. When you're done, copy the code generated by Excel into your VB program (you will have to modify it, slightly, to ensure that it's using the correct excel objects).

[Edited by JHausmann on 08-28-2000 at 07:40 PM]

[timbo]

Hello,

Where exactly can I find the code which is generated by Excel?

Thanks.

[JHausmann]

by selecting Macro..Macros [alt-f8] and chosing the macro you created or by selecting the Macro..Visual Basic Editor [alt f11] and finding it in module1. Both are invoked from the "tools" menu, if you choose not to use the alt key to get there...