Colorization - Revision history

Mtabadmin at 20:53, 31 July 2013

2013-07-31T20:53:28Z

Mtabadmin at 22:11, 29 July 2013

2013-07-29T22:11:00Z

Mtabadmin at 22:47, 17 July 2013

2013-07-17T22:47:10Z

Mtabadmin at 22:44, 17 July 2013

2013-07-17T22:44:21Z

Mtabadmin: Created page with " Adding background color to cells is possible in mTAB. Customizing the cellbackground color allows for easier data tracking and comparisons in the spreadsheet view and even ca..."

2013-07-17T22:25:38Z

Created page with " Adding background color to cells is possible in mTAB. Customizing the cellbackground color allows for easier data tracking and comparisons in the spreadsheet view and even ca..."

New page

Adding background color to cells is possible in mTAB. Customizing the cellbackground color allows for easier data tracking and comparisons in the spreadsheet view and even carries forward to other areas, such as the TopN report.

From the spreadsheet view, cell coloring can be added in a number of ways.

In the first way, an area of the spreadsheet can be highlighted by right-clicking and then selecting Format and then Range.
The dialog that appears offers the ability to change the font size, colorand style, to change numerous attributes of the cell, such as number of decimal places or % indication on/off and provides control of the background color for the cell.
The other method is to again highlight a range of cells from the spreadsheet and then to go to Appearance on the ribbon at the top of the spreadsheet and use the Background Color (paint bucket) toolbar icon. This offers a drop down list of available colors for you to choose from.

By repeating this process, we can color any areas of the spreadsheet that we wish. You will note that the colors can be applied either to the numerical cells, the question response text or any combination of the two that we require.
Not only can coloring be added to the spreadsheet to call out interestingitems, it can be used to track those items during the use of the TopN Report. If we select columns D thru H and run a TopN Report, we see thefollowing.
The cell coloring that was used in the spreadsheet has been carried to thereport and allows us to visually track the placement of a response from brand to brand.

In this case for example, we can immediately see that "ConvenientLocation" is rated highest for Brand A and second highest for Brand G.
This method of cell coloring in the TopN Report is incredibly useful, but is not the only coloring tool we have available in this view.

Added to the TopN view, we have the "TopN Color Options" tool barbutton.
If we started with an uncolored spreadsheet and clicked on this button a dialog appears.

The dialog shows the most frequently mentioned responses from the selectedrow question and for each assigns a color.
It offers the ability for the user to change the font, color and overalllook for each response, through the use of the Change button, along with aselector for the user to decide how many responses will be colored.
The Colorize check box allows this feature to be easily turned on and offwhen needed and the Save Formatting as Default button allows a user tocustomize the colors, fonts, etc used for their TopN Colorize view and to save those settings to be used in each mTAB session.

Checking Colorize and clicking the OK button colors the TopN Report asshown.
Again, the colors allow us to visually track responses from column tocolumn. You will note that some cells are left uncolored and these would be ones that did not fall in the set of most popular responses for that question that you asked to have colored.
With either method of coloring, the resulting spreadsheet or TopN Report can be exported to an Excel or HTML format and all of the cell formatting will be maintained in the exported file.

@@ Line 7: / Line 7: @@
 In the first way, an area of the spreadsheet can be highlighted by right-clicking and then selecting '''Format''' and then '''Range'''.
-[[File:TopN colorization format-range.jpg|thumb|center|x300px]]
+[[File:TopN Colorization select-format-range.jpg|thumb|center|x300px]]
 The dialog that appears offers the ability to change the font size, color and/or style as well as the numerous attributes of the cell, such as number of decimal places or % indication on/off. Further, the dialog provides control of the background color for the cell.
@@ Line 14: / Line 14: @@
 The other method is to again highlight a range of cells from the spreadsheet and then to go to '''Appearance''' ribbon and select the '''Background Color''' (paint bucket) icon. This offers a drop down list of available colors for you to choose from.
-[[File:TopN colorization paint-bucket.jpg|thumb|center|x300px]]
+[[File:TopN Colorization appearance-paint-bucket.jpg|thumb|center|x300px]]
 By repeating this process, we can color any areas of the spreadsheet that we wish. You will note that the colors can be applied to the numerical cells, the question response text, or any combination of the two that we require.
-[[File:TopN colorization column-row.jpg|thumb|center|x300px]]
+[[File:TopN Colorization spreadsheet-row-column-color.jpg|thumb|center|x300px]]
 Not only can coloring be added to the spreadsheet to call out interesting items, but also can be used to track those items during the use of the TopN Report. If we select columns D thru H and run a TopN Report, we see the following:

@@ Line 1: / Line 1: @@
-Adding background color to cells is possible in mTAB. Customizing the cell background color allows for easier data tracking and comparisons in the spreadsheet view and even carries forward to other areas, such as the TopN report.
+mTAB allows users to add background colors to cells. Customizing the cell background color allows for easier data tracking and comparisons in the spreadsheet view and even carries across to other areas, such as the TopN report.
@@ Line 5: / Line 5: @@
-In the first way, an area of the spreadsheet can be highlighted by right-clicking and then selecting Format and then Range. [[File:TopN colorization format-range.jpg|thumb|center|x300px]]
+In the first way, an area of the spreadsheet can be highlighted by right-clicking and then selecting '''Format''' and then '''Range'''.
-The dialog that appears offers the ability to change the font size, color and style, to change numerous attributes of the cell, such as number of decimal places or % indication on/off and provides control of the background color for the cell.
-The other method is to again highlight a range of cells from the spreadsheet and then to go to Appearance on the ribbon at the top of the spreadsheet and use the Background Color (paint bucket) toolbar icon. This offers a drop down list of available colors for you to choose from. [[File:TopN colorization paint-bucket.jpg|thumb|center|x300px]]
+The dialog that appears offers the ability to change the font size, color and/or style as well as the numerous attributes of the cell, such as number of decimal places or % indication on/off. Further, the dialog provides control of the background color for the cell.
-Not only can coloring be added to the spreadsheet to call out interesting items, it can be used to track those items during the use of the TopN Report. If we select columns D thru H and run a TopN Report, we see the following.  [[File:TopN colorization topN-holds-color.jpg|thumb|center|x300px]]
+The other method is to again highlight a range of cells from the spreadsheet and then to go to '''Appearance''' ribbon and select the '''Background Color''' (paint bucket) icon. This offers a drop down list of available colors for you to choose from.
 The cell coloring that was used in the spreadsheet has been carried to the report and allows us to visually track the placement of a response from brand to brand. In this case for example, we can immediately see that "Convenient Location" is rated highest for Brand A and second highest for Brand G. This method of cell coloring in the TopN Report is incredibly useful, but is not the only coloring tool we have available in this view.
-Added to the TopN view, we have the "TopN Color Options" tool bar button. If we started with an uncolored spreadsheet and clicked on this button a dialog appears. [[File:TopN colorization color-TopN.jpg|thumb|center|x300px]]
+Added to the TopN view, we have the '''TopN Color Options''' toolbar icon. If we started with an uncolored spreadsheet and clicked on TopN Color Options, this dialog appears.
-The dialog shows the most frequently mentioned responses from the selected row question and for each assigns a color. It offers the ability for the user to change the font, color and overall look for each response, through the use of the Change button, along with a selector for the user to decide how many responses will be colored.
-The Colorize check box allows this feature to be easily turned on and off when needed and the Save Formatting as Default button allows a user to customize the colors, fonts, etc used for their TopN Colorize view and to save those settings to be used in each mTAB session. [[File:TopN colorization topN-colored-auto.jpg|thumb|right|x250px]]
+The dialog shows the most frequently mentioned responses from the selected row question and assigns a color for each. It offers the ability for the user to change the font, color and overall look for each response through the use of the '''Change''' button. Users can change the number of responses colored by adjusting the '''Auto Color First TopN Responses''' box.
-Checking Colorize and clicking the OK button colors the TopN Report as shown.
+The '''Colorize''' check box allows this feature to be easily turned on and off when needed and the '''Save Formatting as Default''' button allows a user to customize the colors, fonts, etc used for their TopN Colorize view and to save those settings to be used in each mTAB session.
-Again, the colors allow us to visually track responses from column to column. You will note that some cells are left uncolored and these would be ones that did not fall in the set of most popular responses for that question that you asked to have colored.
+[[File:TopN colorization topN-colored-auto.jpg|thumb|right|x250px]]
 With either method of coloring, the resulting spreadsheet or TopN Report can be exported to an Excel or HTML format and all of the cell formatting will be maintained in the exported file.

@@ Line 17: / Line 17: @@
-Added to the TopN view, we have the "TopN Color Options" tool bar button.
+Added to the TopN view, we have the "TopN Color Options" tool bar button. If we started with an uncolored spreadsheet and clicked on this button a dialog appears. [[File:TopN colorization color-TopN.jpg|thumb|center|x300px]]
-If we started with an uncolored spreadsheet and clicked on this button a dialog appears. [[File:TopN colorization color-TopN.jpg|thumb|center|x300px]]
+The dialog shows the most frequently mentioned responses from the selected row question and for each assigns a color. It offers the ability for the user to change the font, color and overall look for each response, through the use of the Change button, along with a selector for the user to decide how many responses will be colored.
 The dialog shows the most frequently mentioned responses from the selected row question and for each assigns a color.
-It offers the ability for the user to change the font, color and overall look for each response, through the use of the Change button, along with a selector for the user to decide how many responses will be colored.
+The Colorize check box allows this feature to be easily turned on and off when needed and the Save Formatting as Default button allows a user to customize the colors, fonts, etc used for their TopN Colorize view and to save those settings to be used in each mTAB session. [[File:TopN colorization topN-colored-auto.jpg|thumb|right|x250px]]
 Checking Colorize and clicking the OK button colors the TopN Report as shown.
 Again, the colors allow us to visually track responses from column to column. You will note that some cells are left uncolored and these would be ones that did not fall in the set of most popular responses for that question that you asked to have colored.