Butterfly Chart
This will be useful in comparing two data sets contrasting each other such as male vs female, income vs expense, positive vs negative, completed on time vs overdue, etc.,
Creating a Butterfly Chart
Zoho Analytics supports the following types of butterfly charts.
Single Series Chart with Color
You can create a butterfly chart for a single metric (Y-axis) grouped by multiple dimensions i.e., by X-axis and Color. The butterfly chart will compare the metric by two color values.
Follow the below steps to create a butterfly chart with a single Y and color.
- Open the chart editor. Drop columns as given below.
-
X-axis
- Drop a dimension column
-
Y-axis
- Drop a metric column
-
Color
- Drop the column to group by color. The data will be compared based on the color column.
-
X-axis
- Drop a dimension column
-
Click the
Click here to Generate Graph
button. A default chart (line or bar, typically) with color categorization gets created.
-
Change the chart type to
Butterfly
. Two horizontal bars are plotted based on the Color value to compare the data.
-
Butterfly chart can compare only two values at a time. In case you have more than two color values in your data, by default, the first two values will be displayed in the chart. You can choose other values to compare, using the legend in the chart view mode.
The following animation illustrates how to create a butterfly chart comparing male vs female fans count based on age for your Facebook page.
Multi Series Chart
You can create a butterfly chart comparing multiple metrics (Multi Y-axes) grouped by the same X-axis.
Follow the below steps to create a multi-Y butterfly chart.
- Open the chart editor. Drop columns as given below.
-
X-axis
- Drop a dimension column
-
Y-axis
- Drop multiple metric columns
-
X-axis
- Drop a dimension column
-
Click the
Click here to Generate Graph
button. A multi Y chart will be created.
-
Change the chart type to
Butterfly
. Data from two Y-axis metrics will be displayed as a butterfly chart to compare the data easily.
-
Butterfly chart can compare two values at a time. In case you have more than two columns in the Y-axis, then you can choose the columns to compare using the legend in the chart view mode. By default, the first two axis values will be displayed in the chart.
The following animation illustrates how to create a butterfly chart comparing positive and negative reactions for your Facebook posts every day.
Possible combinations for creating Butterfly Charts
The following combinations of column types are possible when creating butterfly charts.
|
|
X-axis
|
Y-axis
|
Color
|
Text
|
Tooltip
|
|
Case 1
|
Dimension
|
Aggregate
|
Dimension
|
Aggregate/Optional
|
Aggregate/Optional
|
|
Case 2
|
Dimension
|
Multiple Aggregate
|
-
|
Aggregate/Optional
|
Aggregate/Optional
|
-
Dimension:
A column with Actual Value function applied over it. For numeric columns, the Actual value will be divided into Actual Measure, Actual Dimension, and Actual Range, from which you can choose the appropriate function.
-
Aggregate:
A column with an aggregate function (sum, average, count, etc) applied over it. This also includes the aggregate formula columns.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Chart Types Primer
You can create various types of charts such as Area, Bar, Bubble, Line, Pie, Stacked, Scatter, Funnel, Web and 3D charts by simply dragging and dropping the required columns into the respective shelves in the design area. Before we proceed any ...Working with Chart
Working with Chart Zoho Analytics offers a wide range of interactive options on a chart when accessed by an end-user. The options include interactive chart highlighting, changing chart type, dynamic filtering of data displayed, sorting, viewing ...Bar Chart
Bar charts display values as individual bars whose height is determined by the value plotted and grouped by each category. This is best used to compare data classified into discrete groups. They are generally used to categorize data or represent two ...Histogram Chart
Histogram Chart is a special form of bar chart where the values are plotted over continuous rather than discrete categories and useful to plot frequency distributions. Creating a Histogram chart Follow the below steps to create a Histogram chart. ...Funnel Chart
The Funnel chart is typically used to represent a progressive flow of a business metric, across phases. For example, a sales pipeline progressing from Evaluation - Initial Offering - Quote/Negotiation - Closed Lost - Closed Won. Or a marketing funnel ...