My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Variable Ranges for a Chart
|
|
 Jun 11 2006, 05:18 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 162 From: Indiana, US  |
I work basicaly with access but as we all know access falls short when it comes to charts especially when you need to be able to transfer to Word and Power Point.My problem is that I am populating an Excel spread sheet from Access and trying to create my First chart in VB. I used a macro to get going and have modified it from there, all works well but the data ranges are subject to change depending on the amount of time the user is viewing. Primarily I am building Line Charts with 2 lines and the X Axis value being Date driven. On the static chart the code looks like this:
Range(I2:I22,J2:J22) The ranges cange in length and I cant figure out how to incorporate that in code. I have tried using The xlUp function and it works fine if I am only trying to view one dataseries. Any ideas would be great. Thanks in advance Dan |
 |
 
|
|
Jun 12 2006, 04:51 AM
Post
#2
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
|
|
|
|
|
Jun 12 2006, 12:35 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 162 From: Indiana, US |
Thanks KingMartin
I will not have the opportunity to incorporate for a couple of days but at a glance it looks perfect. Royal in fact! |
|
|
|
|
Jun 12 2006, 06:33 PM
Post
#4
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
You're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)
Post back in case of problems Martin |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 02:23 PM |