[ExcelVBA] using spinboxes to display a surface charts from a large dataset

 

Good afternoon!

I have a 100 column dataset with 14000 rows of values in cells c2 to cy14000

the top row B2 across is a reading number

the column

I am trying to set up a surface chart that displays a rectangular
snapshot of the information

the surface plot is always full width 100 values across

the display is defined by a start and end row in two cells

I have been trying to use OFFSET() and named ranges/cell to do this
but to no avail

Can anyone assist please, sincere apologies if this appears to be a
simple question but I am missing that spark of wisdom needed to finish
the job???

Regards

John
Tarmac Doctor
Southampton UK

--

===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

---

Posted by: Dr John C Bullas <john.bullas@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___