Logo
    Search

    109 Excel | How to compare values visually?

    en-usDecember 17, 2010

    About this Episode

    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. - Office ToDo

    Recent Episodes from Daily Office Tips by Office ToDo

    139 Excel | How to add, remove or reposition text used to label each axis?

    139 Excel | How to add, remove or reposition text used to label each axis?
    Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection. - Office ToDo

    134 Excel | How to display a contribution of each value to a total on a chart?

    134 Excel | How to display a contribution of each value to a total on a chart?
    Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Pie” choose the type of the pie chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

    131 Excel | How to compare values across categories on a chart?

    131 Excel | How to compare values across categories on a chart?
    Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Column” choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo