software

To All --
I have two years' worth of individual production data, one month per page.
On each page, I have a list of individuals' production in different
departments, summing up to a column of totals for that individual that month.I want to create a histogram (using data analysis toolpak) comprised of
those monthly totals for each individual, so I get a sense of the
distribution.

When I create the histogram using one page's worth of data, it works fine.
When I select the same range of cells across all 24 pages, I get an error
message saying that the range is invalid.

What am I doing wrong?

Why not make a summary page with the month/year, individual, total
production?
Without know the sheet layout I cannot be more specific
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;pdbergerquot; gt; wrote in message
...
gt; To All --
gt; I have two years' worth of individual production data, one month per page.
gt; On each page, I have a list of individuals' production in different
gt; departments, summing up to a column of totals for that individual that
gt; month.
gt;
gt;
gt; I want to create a histogram (using data analysis toolpak) comprised of
gt; those monthly totals for each individual, so I get a sense of the
gt; distribution.
gt;
gt; When I create the histogram using one page's worth of data, it works fine.
gt; When I select the same range of cells across all 24 pages, I get an error
gt; message saying that the range is invalid.
gt;
gt; What am I doing wrong?
Thanks, Bernard. Something I was hoping to avoid but, if that's the easiest
way, that's what I'll do.

quot;Bernard Liengmequot; wrote:

gt; Why not make a summary page with the month/year, individual, total
gt; production?
gt; Without know the sheet layout I cannot be more specific
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;pdbergerquot; gt; wrote in message
gt; ...
gt; gt; To All --
gt; gt; I have two years' worth of individual production data, one month per page.
gt; gt; On each page, I have a list of individuals' production in different
gt; gt; departments, summing up to a column of totals for that individual that
gt; gt; month.
gt; gt;
gt; gt;
gt; gt; I want to create a histogram (using data analysis toolpak) comprised of
gt; gt; those monthly totals for each individual, so I get a sense of the
gt; gt; distribution.
gt; gt;
gt; gt; When I create the histogram using one page's worth of data, it works fine.
gt; gt; When I select the same range of cells across all 24 pages, I get an error
gt; gt; message saying that the range is invalid.
gt; gt;
gt; gt; What am I doing wrong?
gt;
gt;
gt;

pdberger -

After you use Bernard's suggestion, if you regard your data as quot;many many
valuesquot; so that it is nearly continuous, and if you want a slightly better
looking histogram, try my free Better Histogram add-in, available for
download from www.treeplan.com.

- Mike
www.mikemiddleton.com

quot;pdbergerquot; gt; wrote in message
...
gt; Thanks, Bernard. Something I was hoping to avoid but, if that's the
gt; easiest
gt; way, that's what I'll do.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Why not make a summary page with the month/year, individual, total
gt;gt; production?
gt;gt; Without know the sheet layout I cannot be more specific
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;pdbergerquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; To All --
gt;gt; gt; I have two years' worth of individual production data, one month per
gt;gt; gt; page.
gt;gt; gt; On each page, I have a list of individuals' production in different
gt;gt; gt; departments, summing up to a column of totals for that individual that
gt;gt; gt; month.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; I want to create a histogram (using data analysis toolpak) comprised of
gt;gt; gt; those monthly totals for each individual, so I get a sense of the
gt;gt; gt; distribution.
gt;gt; gt;
gt;gt; gt; When I create the histogram using one page's worth of data, it works
gt;gt; gt; fine.
gt;gt; gt; When I select the same range of cells across all 24 pages, I get an
gt;gt; gt; error
gt;gt; gt; message saying that the range is invalid.
gt;gt; gt;
gt;gt; gt; What am I doing wrong?
gt;gt;
gt;gt;
gt;gt;