Histogram Plot

[Nikki]

Hello fellow Excel users,

When trying to do a histogram plot I receive the following error
message: "Cannot change part of a merged cell" and then "Histogram -
Cannot draw chart for empty bins"

I am using the Analysis ToolPak Add-In --> Histogram to Output a Graph
in a new worksheet.
As far as I can see, I do not have any merged cells in the ranges I
have selected.

Has anyone else encountered this error message? Is there something
simple I'm not seeing?

Any help is appreciated.
Thank you!
Nikki

[Michael R Middleton]

Nikki -

I have not seen those error messages from the Histogram tool, and I am not
able to replicate your experience.

If you cannot solve the problem, please try my free Better Histogram tool,
available for download at www.treeplan.com.

- Mike
www.mikemiddleton.com

"Nikki" <bloms.nicole@marshfieldclinic.org> wrote in message
news:1139606627.112420.55880@z14g2000cwz.googlegroups.com...
> Hello fellow Excel users,
>
> When trying to do a histogram plot I receive the following error
> message: "Cannot change part of a merged cell" and then "Histogram -
> Cannot draw chart for empty bins"
>
> I am using the Analysis ToolPak Add-In --> Histogram to Output a Graph
> in a new worksheet.
> As far as I can see, I do not have any merged cells in the ranges I
> have selected.
>
> Has anyone else encountered this error message? Is there something
> simple I'm not seeing?
>
> Any help is appreciated.
> Thank you!
> Nikki
>