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 readingTag Archives: compare
How to compare pairs of values? | Excel 2007
Best used for this is the scatter chart. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Scatter” choose the type of scatter that suits you best. Unfortunately no live preview is available on this case.
Continue readingHow to compare values across categories on a chart? | Excel 2007
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.
Continue readingHow to compare two different documents? | Word 2007
When you have Word opened, go to the ribbon under Review tab and select “Compare” from the Compare section. From the list choose again “Compare”. Choose from the appearing menu the original and revised document.
Continue reading