can bin range for histograms be on a different worksheet?

[onereallyfrustratedcamper]

I'm doing the histograms for a bunch of test data like I've done the past few
years. However, I have a new machine and new version of office (Office 2004
X)...

So, I have all the data on one work sheet- it's 1800+ rows, and I use
auto-filter to pare down to the sub-sets I want to histogram. Here is the
problem, however.

I used to have a worksheet to put the bin ranges on. It used to work just
fine that way. Now, however, it appears to not like the bin range reference
if it refers to other than the worksheet with the data? That sucks if it's
true, and will make Excel totally unsuitable for my task

So can anyone confirm that this is the case, that it's a bug, or does anyone
even use Excel for these things?
-one really frustrated camper

[Mike Middleton]

I don't have a useful answer, but since you're using Office 2004 (which is
available only for Macintosh), if you don't get replies here, you may want
to post in microsoft.public.mac.office.excel on msnews.microsoft.com.

- Mike
www.mikemiddleton.com

"onereallyfrustratedcamper"
<[email protected]> wrote in message
news:[email protected]...
> I'm doing the histograms for a bunch of test data like I've done the past
> few
> years. However, I have a new machine and new version of office (Office
> 2004
> X)...
>
> So, I have all the data on one work sheet- it's 1800+ rows, and I use
> auto-filter to pare down to the sub-sets I want to histogram. Here is the
> problem, however.
>
> I used to have a worksheet to put the bin ranges on. It used to work just
> fine that way. Now, however, it appears to not like the bin range
> reference
> if it refers to other than the worksheet with the data? That sucks if
> it's
> true, and will make Excel totally unsuitable for my task
>
> So can anyone confirm that this is the case, that it's a bug, or does
> anyone
> even use Excel for these things?
> -one really frustrated camper