| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a column to show bars
Hi,
A presenter showed us a feature in Excel that convert a column of numbers into number with bars under it. how is it done? i.e. say column B has the following: 23 214 33 236 then the 236 will have somehting like a 2D bar chart under it being the longest and 23 will have the shortest. thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format a column to show bars
thanks for the quick reply.
It is the Data Bars in Conditional Formatting. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show scroll bars and tabs in Excel 2007 | Setting up and Configuration of Excel | |||
| How do I format a column to show a negative percentage in red? | Excel Discussion (Misc queries) | |||
| How do i break really long bars to show short ones in Excel? | Charts and Charting in Excel | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) | |||
Linear Mode
