Tag Archives: values

How to see top values within my list? | Excel 2007

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Top 10 Items …” In the menu you can choose the number of top values shown. By default the number is 10. From the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. 

Continue reading

How to compare values visually? | Excel 2007

Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home tab into Style section. From the row click on the first button called “Conditional Formatting”. From there click on “Data Bars” and apply the style of your liking. Another option would be to add icons inside the cells representing the values compared to other values in the selection. Again, go to the “Conditional Formatting” button and choose “Icon Sets” from the menu. This view offers more possibilities so hover over to see the preview and decide which suits you best. 

Continue reading

How to see bottom values within my list? | Excel 2007

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”.  From there choose “Top/Bottom Rules” and “Bottom 10 Items …” In the menu you can choose the number of bottom values shown. By default the number is 10. From the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. 

Continue reading

How to compare multiple values on a chart? | Excel 2007

Best used for displaying multiple values comparison is a chart with bars. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Bar” choose the type of bars that suit you best. Unfortunately no live preview is applicable in this case.  

Continue reading