How to create a histogram that updates when I filter the input ran

=?Utf-8?B?UGF1bCBUcmVsYw==?=

Guest

Posts: n/a

21st Feb 2006

I want to be able to run an advance filter on an input range and have a
histogram that automatically updates to reflect the filtered range. This
works on regular Excel charts. I am using the Frequency function to create
the histogram.
Help?

« Mail Merge in Excel | sumproduct help »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
histogram is counting input data wrong	Jake	Microsoft Excel Misc	2	22nd Jan 2010 10:44 PM
Excel Histogram - Input Range must be contiguous reference	Giermann	Microsoft Excel Misc	1	20th Aug 2008 08:02 PM
How do you enter input range for a histogram	=?Utf-8?B?SXJpc2hyb3NlMjg=?=	Microsoft Excel Misc	1	4th Aug 2006 02:41 PM
How do you enter input range for a histogram	=?Utf-8?B?SXJpc2hyb3NlMjg=?=	Microsoft Excel Misc	0	4th Aug 2006 02:21 PM
histogram, wrong input range	=?Utf-8?B?Q2FtaWxsYQ==?=	Microsoft Excel Misc	1	11th Nov 2005 07:21 AM