Difference between revisions of "Colorization"
From mtab wikisupport
(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...") |
|||
| 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. | |
| − | Adding background color to cells is possible in mTAB. Customizing the | + | |
| − | From the spreadsheet view, cell coloring can be added in a number of ways. | + | 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. | + | 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]] |
| − | The dialog that appears offers the ability to change the font size, | + | 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]] | ||
| − | In this case for example, we can immediately see that " | + | 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.[[File:TopN colorization column-row.jpg|thumb|center|x300px]] |
| − | 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. | + | |
| + | 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 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 | + | 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. | + | 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 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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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. | 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. | ||
Revision as of 17:44, 17 July 2013
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.
From the spreadsheet view, cell coloring can be added in a number of ways.
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 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.
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.
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.
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.
