This article describes how to go from a bar, column, or funnel (pyramid) chart that has a single series of data shown in one color, like this:
To a chart that shows the values using a gradient, where the color saturation is determined by the values in the chart, like this:
Requirements
- A bar, column, or funnel visualization with a single series (i.e., it cannot be a stacked or clustered visualization)
- Note that legacy visualizations with "with Tests" in the name are not compatible.
- A table containing the same data as used in the chart. This table:
- Should contain exactly the same row labels as used in the chart.
- Can be the same table used to create the visualization if it's created using Data > Data Source > Data.
Method
- Select the visualization on the Page.
- Under Data > Row Manipulations, check the boxes labeled Sort rows and Sort in decreasing order.
- Under Chart > Data Series, check the box labeled Multiple colors within a single series.
- Under Chart > Data Series > Color palette, select a palette that goes from "dark to light" or "light to dark" (these are gradients). The example above uses Reds, light to dark.
- Under Chart > Data Series > Value,s select the table that contains the values to use for the gradient.
- Make sure Calculate automatically is checked (or click Calculate).
Next
How to Create a Clustered Bar Chart
How to Create a Stacked Bar Chart
How to Create Several Bar Charts Using Small Multiples
How to Create a Clustered Column Chart
How to Create a Stacked Column Chart
How to Create Several Column Charts Using Small Multiples
How to Add a Line to a Column Chart (Second Y-Axis)
How to Customize the Color of a Single Category in a Bar, Column, or Pyramid Visualization
UPCOMING WEBINAR: 10 Market Research Predictions Over the Next 4 Years