Tiling Charts in VBA

S

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
I would like to be able to produce a number of line charts and place them into an existing worksheet. Is it possible to have them placed into a sheet in the same way something like
Code: 
Range("A1").End(xlDown).Offset(1,0)
would select the next cell below the last occupied cell? Ideas?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
You must log in or register to reply here.

Similar threads

N
  • Question
How To Create a Gauge-Style Doughnut Chart that Includes Negative & Greater than 100% Numbers
Replies
0
Views
715
NTLKnight
N
B
  • Question
Is it accurate that Excel's 'forecast sheet' function can only work with one series at a time?
Replies
2
Views
109
Jon Peltier
J
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
307
Nick Loughton
N
O
  • Solved
For the millionth time... Trying everthing I can think of the get the last occupied column in a row using a cell in the row.
Replies
2
Views
301
OaklandJim
O
JoeMajestee
  • Solved
How to refer to a shape added to a chart
Replies
2
Views
350
JoeMajestee
JoeMajestee

Forum statistics

Threads
1,216,021
Messages
6,128,319
Members
449,440
Latest member
Gillian McGovern

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top