3 Ways to Make Beautiful Bar Charts in Oracle Analytics Cloud

Next, navigate to the Visualizations pane, select, drag, and drop Bar into the canvas. 

With the Bar chart visualization added to the view, we now need to add at least one dimension to Category and one measure to Values. From the Data pane, drag Sales onto Values and Product onto Category.

Oracle Analytics’ default formatting options allow users to quickly elevate the basic out-of-the-box bar chart into something more engaging and presentable. The first round of changes will aim to improve the data-ink ratio of this chart. The data-ink ratio is a concept introduced by Edward Tufte, who says you should dedicate as much ‘ink’ on a view to the data as possible. This means getting rid of unnecessary lines, effects, and anything else that detracts from the data itself. 

Your visual analytics journey has just begun.

Preview your account dashboard and learn how Playfair+ can support you.

Get started

In the Properties pane, choose the Axis tab. From here, change the Labels and Values Axis Title to None, the Number Format to Currency, Decimal Places to 0, and change the abbreviation to millions by adjusting Abbreviate to M.

Next, sort the chart from High to Low by choosing the Sort button from the visualization toolbar. This technique allows you to not only compare the preattentive attiribute of height in the bars, but their rank order from left to right.

2. Adding direct labels to bar charts in Oracle Analytics

Direct labeling a bar chart has several benefits including an improved data-ink ratio, easier comparison of bars that are close in value, and elevating the overall design. It is important to note that when you choose to directly label a chart, you must always consider removing the y-Axis to not double-encode the chart.

Double-encoding refers to using two different visual cues, also called preattentive attributes, to represent the same data point. This can either be beneficial or problematic to your data visualization, depending on the use-case. 

One way that double-encoding can be beneficial is by providing clarity. For example, if one encoding is hard to interpret (e.g., color-blind users may struggle with color), the second one provides backup. But be aware that if it isn’t used correctly, double-encoding can create chart junk or confusion. It can also be redundant in simple charts, adding no extra value. 

Opting to not double-encode this chart, the first step is to remove the grid lines and the y-Axis. Using the bar chart built in the last section, navigate to the Properties pane, choose the Axis tab, change Grid Lines to Off, and Values Axis Labels to Off. 

To add direct labels, navigate to the Values tab in the Properties pane, change the Data Labels Position to Above, Number Format to Currency, Decimal Places to 0, and change the abbreviation to thousands by adjusting Abbreviate to K. 

3. Add caps to Oracle Analytics bar charts

Adding caps to bar charts in Oracle Analytics can elevate the design and create an additional comparison point, but there are drawbacks. In the words of Playfair Data’s founder, Ryan Sleeper, “the size of the cap can represent the value of a goal or be colored by a different measure (i.e., length of the bars represent sales; color of caps represent profitability). While I like the style of capped bars and the subtle way they can provide additional information, beware they can easily be confused with stacked bar charts, and should be used with caution.”. 

Learn to navigate uncharted waters.

Upgrade to Core or Premium benefits to take your data skills even further.

Learn more

We’ll build off of the bar chart in the last section to create a capped bar chart in Oracle Analytics Cloud. Start by creating a new calculation. To do so, navigate to the Data pane, select the plus icon next to the search bar, and choose “Create Calculation”. 

Bar caps in Oracle Analytics are built with a stacked bar chart, where the sales value represents the bottom bar and the bar cap is the top bar. In this example, the bar caps will be sized using a dynamic value based on a percentage of the total Sum of Sales in the view. The purpose of the dynamic sizing value is to ensure that the cap remains the same size relative to the actual bars in the view. If the bar chart changes in value, then the cap will remain the same size. If a static number is used, like 100, then the cap size would fluctuate depending on the values of the bar chart. 

Name the calculation “bar caps”. The syntax is as follows: 

SUM(Sales) *.01

Click “Save”. In the Grammar pane, add the ‘bar caps’ calculation to Values, above the Sales measure. 

Change the visualization type from Bar to Stacked Bar. 

The visualization is starting to take shape, but I will make one design change to make the main bars a lighter shade and the caps a darker shade of the same color blue. This will both decrease the likelihood that the caps are mistaken as a stacked bar chart with separate values (as opposed to bar caps) and improve the branding of the chart. 

In the Grammar pane, select the dropdown in the Color drop zone and choose Manage Assignments. 

Change the bar caps to a dark shade of blue and the Sales bars to a lighter shade of the same base color. 

The last step in the process is to clean up the view by removing the legend and adding the direct labels. Remove the legend by navigating to the Properties pane, and choosing the General tab (gear icon). Then, next to Legend Position, choose None. 

Navigate to the Sales dropdown in the Values tab. Next to Data Labels Position, deselect Apply to All Measures and select Top. Change the Number Format to Currency, Decimals to 0, and Abbreviation to K. Here is how my final view looks.

While there are other bar chart variations and applications, implementing these three methods to create bar charts in Oracle Analytics will unlock a great deal of value for your data visualizations and stakeholders.

Thanks for reading!
Dan