This page documents the various options available through the chart editor. In the Classic version of MarketSight, options marked with a blue asterisk only affect exports to PowerPoint. Options marked with a green asterisk affect both PowerPoint exports and the online chart display.
Changing your chart options will occasionally produce option conflicts. Generally, these occur when:
Note: Changes to your chart labeling are saved with the chart and affect only the one chart. It does not change the labels in your underlying crosstab.
Note: This option is only available when working with a single data series.
| Option | Description |
|---|---|
| Calculation |
This dropdown allows you to select the calculation to display. Options shown are based on the calculations included in the underlying crosstab. |
| Show Totals | Displays a total in the chart. |
| Use crosstab rounding settings |
Applies the underlying crosstab's rounding settings to the chart display. |
| Chart Interactivity |
Turn chart interactivity on and off by using these checkboxes. They will be grayed out if the underlying crosstab uses only one row or column variable, or no filter variable. |
| Row Variables |
Lists additional row variables that were included in the underlying crosstab. Selecting additional row variables here will add them to your chart. |
| Option | Description |
|---|---|
| Column |
Shows data for comparison in a vertical format. Multiple styles available. |
| Bar | Shows data for comparison in a horizontal format. Multiple styles available. |
| Line | Effective for showing how data varies between variables. Presents data in a horizontal orientation. Multiple styles available. |
| Pie |
This chart type depicts a single data series as parts of a whole. Multiple styles available. |
| Gauge |
Displays a single data point in a gauge style. Multiple styles available. |
| Option | Description |
|---|---|
| From Template |
Use chart colors from the uploaded PowerPoint template. |
| Custom |
Select individual custom colors themes from previously uploaded PowerPoint templates. |
| Themes | Select a pre-built color theme. |
| Option | Description |
|---|---|
| Apply Chart Styles |
Allows the user to copy display and formatting options from another chart within the same dataset. |
| Use Chart Options from the Template |
When selected, all options for the Display Tab, Category Axis Tab and Numeric Axis Tab are based on the current default template from the Chart Templates page. If the options for the above tabs are grayed out, that means this option is selected. To make changes, you'll need to deselect it. |
| Title |
Formatting options for the chart title. Placement: Change the title location Font Type: Change the font of the title Font Style: Change the style of the title Font Size: Change the size of the title |
| Value labels |
Formatting options for the value labels. Placement: Change the value label placement. |
| Plot area |
Formatting options for the plot area where the chart is located. Show Border: Displays a border around the plot area. Grid Lines: Add extensions of the tick marks on the horizontal or vertical axis, which can make your chart easier to read. |
| Legend |
Formatting options for the chart legend. Placement: Change the legend location. Choose Custom to locate your legend wherever you would like. Show Border: Displays a border around the legend. |
| Sample Size Threshold |
Show a warning when weighted or unweighted sample size is below a set threshold. Warning Message: Enter a custom message here. This warning will appear when the chart sample size falls below the set threshold. Show Current Sample Size: Displays the current chart sample size in the warning message. Show Required Sample Size: Shows the threshold set for the chart. Opacity: Controls the opacity of the warning message that overlays the chart. |
| Additional Display Options |
Sample Size: Adds the sample size to your chart. This option is disabled if your chart contains multiple variables with different sample sizes or if no sample size was shown in the underlying crosstab. Unweighted Sample Size: Available only when weighting is in effect. Adds unweighted sample size to your chart. Filter Details: Adds information about the filters used in your chart. Sample Base: Displays sample base for each category displayed in your chart. Valid Cases (MRVs only): Adds the number of Valid Cases to the chart. (What is the number of respondents who selected at least one answer to a given survey question?) Total Mentions (MRVs only): Adds the number of Total Mentions to the chart. (What is the total number of responses across the entire question?) Unweighted Total Mentions (MRVs only): Adds the unweighted number of Total Mentions to the chart. Only available if weighting is in effect. (What is the total number of responses across the entire question?) Total Unique Mentions (MRVs only): Adds the number of Total Unique Mentions to the chart. (How many different respondents said "Yes" at least once - and possibly more than once - to each option?) |
| Option | Description |
|---|---|
| Use Chart Options from the Template |
When selected, all options for the Display Tab, Category Axis Tab and Numeric Axis Tab are based on the current default template from the Chart Templates page. If the options for the above tabs are grayed out, that means this option is selected. To make changes, you'll need to deselect it. |
| Show Category Axis | Displays the category axis for the chart. |
| Major Tick Mark Type |
Formatting options for the major tick marks. Hide, display within chart area, display outside chart area, or cross (displays both inside and out of the chart area). |
| Minor Tick Mark Type | Formatting options for the minor tick marks. Hide, display within chart area, display outside chart area, or cross (displays both inside and out of the chart area). |
| Axis Labels |
Formatting options for the axis labels. Placement: Change the label location Font Type: Change the font of the labels Font Style: Change the style of the labels Font Size: Change the size of the labels |
| Interval Between Labels |
Specify the interval at which you want categories to be labeled. A smaller interval number causes a greater number of labels to be shown, but too many labels can clutter your chart. Auto: determined by MarketSight Fixed: Specify a number that overrides MarketSight's chosen automatic interval. Type "1" to display a label for every category, "2" to display a label for every other category, and so on. |
| Label Distance from Axis |
Specifies the distance between the axis and axis labels. Smaller numbers will place labels closer to the axis. Larger numbers will move labels further away from the axis. |
| Label Area Size (bar charts only) |
Specify the size of the labels area. A larger label area leaves less space to display chart information. |
| Wrap lines up to ... (bar charts only) |
Causes MarketSight to automatically wrap axis labels after a specified number of characters. |
|
Label Rotation (column/line charts only) |
Rotate the axis labels at a 45 or 90 degree angle. |
| Option | Description |
|---|---|
| Use Chart Options from the Template |
When selected, all options for the Display Tab, Category Axis Tab and Numeric Axis Tab are based on the current default template from the Chart Templates page. If the options for the above tabs are grayed out, that means this option is selected. To make changes, you'll need to deselect it. |
| Show Numeric Axis | Displays the numeric axis for the chart. |
| Minimum Value Maximum Value |
Auto: automatic axis scaling determined by MarketSight, based on the numerical range of data shown in the chart Fixed: Specify a number that overrides MarketSight's auto scaling. |
| Major Tick Mark Type | Formatting options for the major tick marks. Hide, display within chart area, display outside chart area, or cross (displays both inside and out of the chart area). |
| Minor Tick Mark Type | Formatting options for the minor tick marks. Hide, display within chart area, display outside chart area, or cross (displays both inside and out of the chart area). |
| Axis Labels |
Formatting options for the axis labels. Placement: Change the label location Font Type: Change the font of the labels Font Style: Change the style of the labels Font Size: Change the size of the labels |
| Axis Title |
Formatting options for the axis title. Placement: Change the title location Font Type: Change the font of the title Font Style: Change the style of the title Font Size: Change the size of the title |
| Option | Description |
|---|---|
| Add to Key Findings | Adds the item to Key Findings. |
| Show URL |
Gives you a permanent link to the item. This URL can be copy/pasted and sent to other MarketSight users or Customer Service. All permissions settings apply and MarketSight users will need to enter their login credentials to view the item. |
Last Updated: 7/11/2019