All eazyBI for Jira eazyBI for Confluence Private eazyBI

Create charts
eazyBI.com eazyBI for Confluence Private eazyBI eazyBI for Jira

Charts in eazyBI help you visualize data from your reports to spot trends, compare values, and highlight key insights. Once you’ve built a Table report, you can switch to different chart views to present the data visually.

This page explains when to use each chart type and how to adjust chart options for clearer results.

If you’re new to reporting, start with the Create reports section first to learn how to build a report table before moving to charts.

On this page:

Chart types and options

When creating a report, you'll see a Chart type selector [1] to switch between Table, Bar, Line, Pie, Scatter, Timeline, Gantt, Gauge, Radar, and Map charts to visualize the selected data better.

Each chart type has a set of Chart options [2] to adjust layout, formatting, and visibility.

Chart options common for all chart types:

  • Maximize results view – expand chart, hide dimension sections
  • Undo / Redo – revert or repeat recent changes
  • Add description – add a description using Markdown
  • Export report results – download as CSV, XLS, PDF, or PNG (for visual charts)
  • Hide empty – hide rows/columns with no data
  • Total – show row/column totals

Bar chart

Use the Bar chart [1] to compare data across categories using horizontal or vertical bars.
This chart is ideal when you want to:

  • Compare values side-by-side (e.g., sales per store or issues per project)
  • Highlight relative differences between grouped items
  • Show part-to-whole composition using stacked bars

Use the Vertical option to switch from the default horizontal bars to vertical bars (columns).
Enable the Stacked option to split bars by category or status. You can then choose whether to show actual Values or Percentages within stacks.

Bar chart options [2]:

  • Stacked – group values within each bar by row members
  • Vertical – switch from horizontal to vertical bars
  • Values / Percentage – switch between absolute values or percentages (only with Stacked)
  • Data labels – show values on the bars; with Stacked, switch to values, percentage, or both
  • Axes options – adjust X/Y axis settings or Swap axes
  • Font size – change chart font size (small, medium, large)

See the example: Product sales in select cities – shows a stacked bar view of product categories by city.

Line chart

Use the Line chart [1] to show trends over time or across ordered categories.
This chart is ideal when you want to:

  • Track continuous data changes (e.g., weekly sales, monthly issue resolutions)
  • Compare trends between multiple measures
  • Emphasize peaks, drops, and progressions

Enable the Area option to highlight cumulative changes. This fills the space under the lines, making trends and volume easier to read.
Use Stacked (with Area) to group values by row members and show how parts contribute to a total.

Line chart options [2]:

  • Area – fill the space under each line
  • Stacked – group area values by row members (only available with Area)
  • Values / Percentage – switch between absolute values or percentages (only with Stacked)
  • Data labels – show values at each point; with Stacked, switch to values, percentage, or both
  • Axes options – adjust X/Y axis settings or Swap axes
  • Font size – change chart font size (small, medium, large)

See the example: Product sales and cost by time – compares Store Sales and Store Cost weekly using an area chart with stacked values.

Pie chart

Use the Pie chart [1] to show how parts make up a whole. Each slice represents a proportion of the total, shown as values, percentages, or both.

Enable Relative size to scale each pie chart proportionally based on value.

You can enable the Donut option to compare the ratio of the segments between compositions. You can think of a Donut chart as a stacked bar graph that has been curled around on itself.

If you display data labels and percentages for each slice, you can hide the Legend for a cleaner look.

Pie chart options [2]:

  • Donut – switch from a pie to a donut layout
  • Legend – show or hide the chart legend
  • Name labels – display names of each member
  • Data labels – show values, percentages, or both inside slices
  • Relative size – scale charts proportionally based on total value
  • Swap axes – flip dimensions in rows/columns (when applicable)
  • Font size – adjust chart font size (small, medium, large)

See the example: Unit sales by Product family – compares unit sales for two product families with relatively sized pie charts. 

Scatter chart

Use the Scatter chart [1] to explore relationships between two numeric measures. Each data point is placed using a separate measure for the X and Y axis, and the chart adjusts the axis scale automatically.

Enable the Bubble option to use a third measure for bubble size—this helps show how big or important each point is.

To zoom in, drag your mouse across the area you want to focus on.

Scatter chart options [2]:

  • Name labels – show member names next to bubbles
  • Bubble – use a third measure to set the bubble size
  • Axes options – adjust axis titles, label prefix/suffix, or min/max values
  • Font size – change chart font size (small, medium, large)

See the example: Scatter chart – Profit analysis – compares Store Sales and Time across product categories, with Profit shown by bubble size.

Timeline chart

Use the Timeline chart [2] to show continuous data changes over time. It works like a line chart but connects data points across time, even if some time periods have no data.

Start by placing the Time dimension [1] on rows (selecting the desired hierarchy like year, month, or day) and measures on columns. Then switch to the Timeline chart [2] to customize the chart display.

Show values as lines, splines, columns, or areas—whichever fits your data best.

To focus on a time range, drag across the chart to zoom in. To change the period shown in the report, apply a Time filter instead (which saves the filter selection).

Timeline chart options [3]:

  • Line / Spline / Column / Area – switch how all measures are displayed
  • Stacked – group area values by row members (only with Area)
  • Values / Percentage – switch between absolute values or percentages (only with Stacked)
  • Data labels – show values at each point; with Stacked, switch to values, percentage, or both
  • Axes options – adjust Y axis title, label prefix/suffix, or min/max values
  • Font size – change chart font size (small, medium, large)

See the example: Timeline – Sales, Cost, and Unit Sales trends – compares several measures over time using line display.

 

Gantt chart

Use the Gantt chart [1] to illustrate scheduled tasks and their progress on the timeline Daily, Monthly, Quarterly, Yearly, or Fit width [2].

To build a Gantt chart, place projects or tasks on rows and select at least two date measures [3] in columns:

  • Start date – set it as the first column
  • End date – set it right after the start date column

On the timeline, a bar connects the start to the end date. If the start date is missing, then the end date is marked with a diamond.

Optionally, add a completion percentage [4] column (formatted as %). Use values from 0% (not started) to 100% (completed). If the value is below 100% and the end date is in the past, the task appears as overdue.

Drag the vertical separator [5] to show or hide task details in the table, like start date, end date, completion percentage, or other measures.

In Gantt chart, the progress of a task is visualized with colors:

  • Blue – upcoming tasks, milestones, and completed tasks without completion ratio
  • Green – completed tasks with completion ratio (%)
  • Red – overdue tasks with completion ratio (%)
  • Grey – a group of tasks

See the example here: https://eazybi.com/accounts/1000/cubes/Issues/reports/50489-issue-gantt-chart

Gauge chart

Select Gauge [1] chart to show key performance indicators (KPIs) as color-coded gauges with progress towards defined limits. 

Select Gauge limits [3] to set limits for measures and color-code for each limit range. If several gauges are displayed using the same measure and if you want to specify the same limits for all gauges then click on the measure name label in the chart area and select Gauge limits. If you need to add specific limit values for just one gauge then click on the member value and select Gauge limits.

To see an overview, you can use numerical values only [3], and for big numbers select Scaled values [4] to display values using k (thousands) or M (millions) suffixes, etc. Additionally, add a Sparkline calculated measure to show a brief trend next to the number.

You can set a specific numerical Value or percentage as a limit for the gauge. In this case, you may use k suffix to enter thousands, M suffix to enter millions or % suffix to enter a percentage value. Or you can set another Measure as a limit. Note, this measure should be selected for the report as columns as well. To change the default color of Sparkline do not enter any value, but only change the Color of the limit. 

see the example here: https://eazybi.com/accounts/1/cubes/Sales/reports/173837-gauge-chart-with-limit-example-for-demo


Radar chart

Available on Cloud and since eazyBI version 8.1.

A radar chart, sometimes also called a spider or a web chart, represents multivariate data with three or more quantitative variables mapped onto the same axis. It is a good choice when you want to compare multiple measures with the same scale for different dimension members in a compact visual way to see the tendencies and spot outliers. To switch to the Radar chart, click on More → Radar [1]. 

You can represent data as a line or area [2]. For the area, you can also select stacked to show the composition of similar items.

Map chart

If you have some dimension with countries or regions or data with geographical coordinates (latitude and longitude) you can represent data distribution on the Map [1] chart. To switch to the Map chart, click on More → Map. eazyBI provides two types of maps.

You may visit the Demo account to see both map examples: https://eazybi.com/accounts/26241/dashboards/14324-population-and-airports

Static map

Use a Static map when you have regions mapped with the ISO two-letter codes or country names. If you map data with the country names, make sure that the used variations of the county names are recognized in the map chart by eazyBI.

Select dimension containing region and country two-letter codes [1] on rows and necessary measures on columns. The first column [2] is used to calculate the color intensity for each region.

Then switch to Map [1] chart and select Static [2] view. You may also select the region [3], for example - world map, Europe map, or particular country map, to change between available maps. The region color intensity is calculated on measure value [4] from the first column. When hovering a mouse over the region, you see measure values from all columns.

See the example here: https://eazybi.com/accounts/26241/cubes/World%20Population/reports/180168-world-population-2017-by-countries-static-map-chart

Dynamic map

Use dynamic map when you have geographical coordinates (latitude and longitude) for dimension members to represent their location on the map.

Select a dimension containing objects with coordinates on rows and necessary measures and coordinates on columns [1]. The first column should hold latitude and the second column should hold longitude [2] to place coordinates correctly. Use some numeric measure [1] to give a context for the report; this measure might be as the third column or filter.

Then switch to Map chart and select OpenStreetMap view to see how many objects (dimension members) are in each region.


See the example here: https://eazybi.com/accounts/26241/cubes/AirportData/reports/180162-dynamic-map-chart-world-airports

 

Training videos

Save time by checking out training videos: