Category Archives: MS Office

How to easily apply different colors to cells depending on their value? | Excel 2007

To have Excel apply the coloring depending on the values inside the cells, you should apply color scales. To do this, select the cells you wish to be analyzed and go under Home tab into Styles section. From the row click on the first button called “Conditional Formatting”.  From there click on “Color Scales” and apply the style of your liking.  

Continue reading →

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

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. 

Continue reading →