Chart Options

Overview

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:

  • You select a calculation option that is incompatible with your variable selection
  • You combine calculation and variable selections that invalidate the chart format
  • You select a number of additional row variables that either exceeds the maximum number of values or the total quantity of data allowed

Change Labeling In Your Chart

  1. When viewing the chart, click on Format Data Points in the gray toolbar (classic), adjust the labels as desired
  2. When viewing the chart, click on the Edit button > Format Data Points (new), adjust the labels as desired
  3. Click OK to confirm

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.

Change Colors for Individual Data Points

  1. When viewing the chart, click on Format Data Points in the gray toolbar (classic), click the colored square next to the item you wish to change the color for
  2. When viewing the chart, click on the Edit button > Format Data Points (new), click the colored square next to the item you wish to change the color for
  3. Select a websafe color from the palette, or
  4. Enter in hex code/RGB values on the Custom Color tab
  5. Click OK

Note: This option is only available when working with a single data series.

Chart Data Options

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.

Chart Type Options

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.

Color Options

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.

Display Options

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?)

Category Axis

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.

Numeric Axis

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

Share

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.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us