Hi all! Newbie to your forum.
I have recently begun studying Visual Basic from library books and find it most intriguing. I am currently working on a problem of creating multiple charts from multiple ranges of data. For instance:
cells B2 thru E5 have data for chart1
cells G2 thru J5 have data for chart2
cells L2 thru O5 have data for chart3
cells B8 thru E11 have data for chart4
cells G8 thru J11 have data for chart5
cells L8 thru O11 have data for chart6
As you can see - the data will alway be located in array of cells 4wide by 4high.
This goes on for another 6 charts.
One problem I am having besides creating the charts is when no data exists in one of the arrays, no chart should be created.
All charts will be placed on a worksheet named Charts.
Once all charts have been created, I use another sub to automatically size and line up the charts. Then I will use an additional sub to create a gif file for a virtual snapshot of the charts created.
Any help you can offer will certainly be appreciated.
Thanks you
Bookmarks