ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Histograms (https://www.excelbanter.com/excel-discussion-misc-queries/135595-histograms.html)

Motaad

Histograms
 
Can you have a list of columns on a worksheet and point the histogram to
them. In otherwords can you have the histogram change as you point it to
different cells. I have three columns of data and three columns of bins. I
would like the histogram to somehow be able to let the user point it to
different cells and display that information.
--
Motaad

David Biddulph[_2_]

Histograms
 
Sounds like a case for the INDIRECT() function?
--
David Biddulph

"Motaad" wrote in message
...
Can you have a list of columns on a worksheet and point the histogram to
them. In otherwords can you have the histogram change as you point it to
different cells. I have three columns of data and three columns of bins.
I
would like the histogram to somehow be able to let the user point it to
different cells and display that information.
--
Motaad




Motaad

Histograms
 
Is it possible to copy paste special values so you can at least input more
than one histogram on the same page????
--
Motaad


"David Biddulph" wrote:

Sounds like a case for the INDIRECT() function?
--
David Biddulph

"Motaad" wrote in message
...
Can you have a list of columns on a worksheet and point the histogram to
them. In otherwords can you have the histogram change as you point it to
different cells. I have three columns of data and three columns of bins.
I
would like the histogram to somehow be able to let the user point it to
different cells and display that information.
--
Motaad






All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com