| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Bars based on other cells
How do I get data bars in a range of cells based on the values in a different
range of cell? I have two columns: Category and Count. I'd like to have Data Bars appear in the Category column based on the values in the Count column. This feels like it should be easy, but I just can't get there. Thanks in advance! -- Brian |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Bars based on other cells
I think you need a macro to do this, since data bars are based on the cell
in which they reside. There is a sample macro for this in my blog at http://www.edferrero.com/Blog/tabid/...0/Default.aspx Ed Ferrero "Brian Shelden" wrote in message ... How do I get data bars in a range of cells based on the values in a different range of cell? I have two columns: Category and Count. I'd like to have Data Bars appear in the Category column based on the values in the Count column. This feels like it should be easy, but I just can't get there. Thanks in advance! -- Brian |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Bars based on other cells
Hi Ed
Nice piece of code. Thanks for sharing it with us. -- Regards Roger Govier "Ed Ferrero" wrote in message ... I think you need a macro to do this, since data bars are based on the cell in which they reside. There is a sample macro for this in my blog at http://www.edferrero.com/Blog/tabid/...0/Default.aspx Ed Ferrero "Brian Shelden" wrote in message ... How do I get data bars in a range of cells based on the values in a different range of cell? I have two columns: Category and Count. I'd like to have Data Bars appear in the Category column based on the values in the Count column. This feels like it should be easy, but I just can't get there. Thanks in advance! -- Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how update one cell based on another cells data | Excel Discussion (Misc queries) | |||
| Data Validation based on other cells | Excel Worksheet Functions | |||
| Display data from cells based on a formula | Excel Discussion (Misc queries) | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
Linear Mode
