P
pete
Bug in histogram data analysis.
In generating a histogram, when I choose a bin range
and/or output range that are on a different sheet, those
ranges appear entered in A1 format. But when I click "OK",
I get an error message because the bin range and output
ranges have changed to R1C1 notation. (When I go back to
the histo tool I see those ranges in R1C1 notation. If I
change them back to A1, they revert to R1C1 again when I
click OK). So there is no way to specify either a bin or
output range on a different sheet. My workaround is to put
the bin range on the same sheet as the data, and the
output on a new sheet, but that's not what I usually want
to do. BTW, this appears to be unrelated to the A1 vs.
R1C1 option for the application, as all formulae etc.
appear to be in the default A1 format.
Any ideas out there?
In generating a histogram, when I choose a bin range
and/or output range that are on a different sheet, those
ranges appear entered in A1 format. But when I click "OK",
I get an error message because the bin range and output
ranges have changed to R1C1 notation. (When I go back to
the histo tool I see those ranges in R1C1 notation. If I
change them back to A1, they revert to R1C1 again when I
click OK). So there is no way to specify either a bin or
output range on a different sheet. My workaround is to put
the bin range on the same sheet as the data, and the
output on a new sheet, but that's not what I usually want
to do. BTW, this appears to be unrelated to the A1 vs.
R1C1 option for the application, as all formulae etc.
appear to be in the default A1 format.
Any ideas out there?