I just need help!

amueller · Post by **amueller** » Thu Jul 28, 2005 2:09 pm

Hello,

I am trying to emulate a surface chart (area chart) in Excel. I can come relatively close, but not quite. I am sure that Teechart can handle it, but I really don't know how else to try..

I need someone to look at the Excel page, look at my code (VB6), and tell me what I can do to make it look similar.

Anyone?

Narcís · Post by **Narcís** » Thu Jul 28, 2005 3:03 pm

Hi amueller,

You can post your files at [url]news://www.steema.net/steema.public.attachments[/url] newsgroup so that we can have a look at them.

amueller · Post by **amueller** » Thu Jul 28, 2005 4:36 pm

Apparently the database is too large to transfer.

I compacted it (Access DB), but it is still 6.7 MB (combined with the Visual Basic 6.0 Project).

amueller · Post by **amueller** » Thu Jul 28, 2005 4:45 pm

What I mean by that is...

When I tried to upload it, I got a return message that the file was too large (From the NNTP server).

Andrew

amueller · Post by **amueller** » Thu Jul 28, 2005 6:27 pm

C'mon guys....

I am waiting on a simple answer here.. This is an extremely important project that I need help with. Also a short lead time because I am out of town starting Monday and they need this working by then.

Please help me upload this so that you can take a look at it.

Thanks!

Andrew

Narcís · Post by **Narcís** » Fri Jul 29, 2005 8:00 am

Hi Andrew,

You can try to upload it somewhere so that we can download it or you could also post some screen-shots at the newsgroups so that we can try to figure out what is missing on your project.

Thanks in advance.

amueller · Post by **amueller** » Fri Jul 29, 2005 2:01 pm

Here is a place to check out the issue.

http://www.instechnet.com/dl/browse.asp ... artProblem

All you will have to do is hit the 'Get Data' button and you will see how it differs from the Excel spreadsheet (Sheet 2 has the same date query, I believe, so that chart should look like the Teechart).

The only way to get it close is to raise the NumLevels to 2000, and the Pen Width to 10. However, that doesn't work for all of the date ranges..

Thanks,

Andrew

Narcís · Post by **Narcís** » Fri Jul 29, 2005 2:58 pm

Hi Andrew,

Thank you very much for your example.

TeeChart Contour series doesn't fill levels as on your Excel example. You could get an approach to what you request but its very difficult to get almost the same. I have added it to our wish list to be considered for future releases, but it is not possible at the present moment.

amueller · Post by **amueller** » Fri Jul 29, 2005 3:11 pm

How about using the surface chart or the colorgrid??

For example, can I decrease the size of the squares so that it looks a lot better??

Check out the form to see what I mean... Those charts would look a lot better also if the squares were smaller, so that it could plot better.

Thanks