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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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
663
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
78
Jon Peltier
J
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
225
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
291
OaklandJim
O
JoeMajestee
  • Solved
How to refer to a shape added to a chart
Replies
2
Views
336
JoeMajestee
JoeMajestee

Forum statistics

Threads
1,215,193
Messages
6,123,560
Members
449,108
Latest member
rache47

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