This article describes how to go from a bar, column, or 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:
This process is not applicable to visualizations (e.g., Bar, Column), not legacy charts (these are visualizations with the words "with Tests").
Requirements
- A bar, column, or pyramid visualization with a single series (i.e., it cannot be a stacked or clustered visualization)
- 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 Inputs > DATA SOURCE > Output in 'Pages'.
Method
1. Select the visualization on the Page.
2. Under Inputs > ROW MANIPULATIONS check the boxes labeled Sort rows and Sort in decreasing order.
3. Under Chart > DATA SERIES check the box labeled Multiple colors within a single series.
4. 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.
5. Under Chart > DATA SERIES > Values select the table that contains the values to use for the gradient.
6. Make sure Automatic 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 Apply a Gradient Palette to a Bar, Column, or Pyramid Visualization
How to Customize the Color of a Single Category in a Bar, Column, or Pyramid Visualization