PC Review


Reply
Thread Tools Rate Thread

Chart / Scrollbar / Offset / Autofilter

 
 
Oliver
Guest
Posts: n/a
 
      19th Sep 2006
Hi,
I am having the following problem:
I have a chart which refers to 2 columns and serveral rows of a table.
I added a scrollbar to the chart (here I used the offset function to
define the range for my series). This works fine so far. But when I use
the autofilter on my datatable then I have the following problem:
The filter shows line 3 and 96. My ranges I have in my autofilter are
in steps of 10.
It shows me now one bar (for line no 3) then I have to scroll 8 times
up to I get the bar for line 96.
Does anybody has some experience with this and can help me?

Thanks in advance,
Oliver

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offset with scrollbar H.G. Lamy Microsoft Excel Worksheet Functions 3 10th Feb 2010 06:38 PM
Using offset following an autofilter =?Utf-8?B?U3RldmUgVw==?= Microsoft Excel Programming 3 6th Mar 2007 06:53 PM
Using Offset with Autofilter data Moiz Microsoft Excel Programming 1 2nd Oct 2005 11:45 AM
Scrollbar on Chart Jumps to Left when Chart is Clicked Bob Microsoft Excel Charting 5 1st May 2005 03:06 AM
Put ScrollBar on chart. =?gb2312?B?Q2FjdHVzIFvPycjLx/Jd?= Microsoft Excel Discussion 2 24th Jan 2005 05:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:39 PM.