Advanced Analytics
      Back to home
      1. Help Center
      2. Advanced Analytics

      Mastering Bar Charts in Advanced Analytics

      Introduction

      Data visualization is essential for making informed business decisions. Bar charts are one of the most effective ways to compare values across categories or track changes over time. This guide will walk you through creating and customizing bar charts in UpMetrics' Advanced Analytics platform, with easy-to-follow steps for users of all technical levels.

      Getting Started with Bar Charts

      Bar charts are perfect for comparing categorical data and identifying patterns that might otherwise be difficult to spot in raw numbers.

      When to Use Bar Charts

      Bar charts are ideal for:

      • Comparing values across different categories

      • Analyzing trends over time when you want to emphasize individual values

      • Displaying distribution of data across groups

      • Showing part-to-whole relationships when using stacked bars

      Creating Your First Bar Chart

      Let's walk through the step-by-step process of creating a bar chart in UpMetrics Advanced Analytics:

      1. Create a new Chart

      1. Navigate to Advanced Analytics and create a new chart

      2. Select the datatable which contains data you would like to visualize

      3. In the visualization type selector, select Bar Chart from the available options

      4. Click Create Chart

      2. Configure Your Chart

      The chart builder is divided into several panels that allow you to customize your visualization:

      Basic Configuration

      1. In the Data tab:

        • Select the Metric for your Y-axis (what you want to measure)

        • Choose an Aggregate function (SUM, AVG, COUNT, etc.)

        • Select the Dimension for your X-axis

      2. Click the Run button to generate your chart

      Advanced Configuration

      In the Customize tab, you can fine-tune your bar chart:

      1. Chart Options:

        • Toggle between vertical and horizontal orientation

        • Choose between grouped or stacked bars

        • Set bar width and padding

        • Adjust label positioning and rotation

      2. Axes:

        • Format X and Y axis labels

        • Set axis bounds and scale

        • Add grid lines

      3. Colors:

        • Select a color scheme from predefined palettes

        • Set specific colors for individual categories

      4. Formatting and Labels:

        • Add data labels on bars

        • Format number displays (decimals, prefixes, suffixes)

        • Set legend position and format

      Creating Different Types of Bar Charts

      Now that you've mastered the basics, let's explore creating different types of bar charts for various analytical needs.

      Standard Bar Chart

      1. In the Data tab:

        • Set your Metric (e.g., SUM of Revenue)

        • Set your Group by to the category you want to compare (e.g., Product Line)

      2. Click Run to generate the chart

      Stacked Bar Chart

      Stacked bar charts help you see both the total and the composition of each category.

      1. Follow the steps for a standard bar chart

      2. In the Data tab:

        • Add a Series breakout dimension (e.g., Region)

      3. In the Customize tab:

        • Set Bar Stacking to "Stack"

      4. Click Run to update the chart

      Horizontal Bar Chart

      Horizontal bar charts are excellent when you have many categories or long category names.

      1. Create a standard bar chart

      2. In the Customize tab:

        • Toggle the Horizontal Bar Chart option

      3. Click Run to update the chart

      Time Series Bar Chart

      Time series bar charts help track changes over time periods.

      1. In the Data tab:

        • Set your Metric (e.g., SUM of Sales)

        • For Group by, select your time dimension (e.g., Order Date)

      2. In the Time section:

        • Set Time Grain to your preferred time unit (day, week, month, year)

        • Set Time Range to your desired period

      3. Click Run to generate the chart

      Advanced Features

      Adding Reference Lines

      Reference lines help highlight important thresholds or targets.

      1. In the Customize tab, locate the Advanced Analytics section

      2. Click + Add Reference Line

      3. Configure your reference line:

        • Set the value or formula (e.g., 500000 for a $500K target)

        • Choose a label (e.g., "Target")

        • Select a line style and color (e.g., dashed red line)

      4. Click Save to add the reference line to your chart

      Applying Filters

      Filters help focus your analysis on specific data segments.

      1. In the Filters panel:

        • Click + Add Filter

        • Select the column to filter on (e.g., "Product Category")

        • Choose your filter operator (equals, greater than, etc.)

        • Enter filter values (e.g., select "Electronics" and "Furniture")

      2. Click Apply to update your chart with the filter applied

      Sorting Your Data

      Proper sorting makes your bar chart more informative and easier to interpret.

      1. In the Data tab:

        • Find the Sort By option

        • Choose to sort by metric value or dimension name

        • Select ascending or descending order

      2. Click Run to update the chart with the new sorting

      Walk-through Examples

      Example: Sales Analysis by Region

      In this walkthrough, we'll create a bar chart to analyze sales performance by region using a sample dataset. We'll guide you through each step with detailed instructions.

      Step 1. Create a new Chart

      1. Navigate to Advanced Analytics and create a new chart

      2. Select the "Sales Performance" data table

      3. In the visualization type selector, select Bar Chart from the available options

      4. Click Create Chart

      Step 2. Configure Your Chart

      The chart builder is divided into several panels that allow you to customize your visualization:

      Basic Configuration

      1. In the Data tab:

        • Select “Sales” (or your revenue metric) as the Metric for your Y-axis

        • Select “SUM” as the Aggregate function

        • Rename this to “Total Sales” by clicking the pencil icon

        • Select “Region” as the Dimension for your X-axis

        • This will set your X-axis to show different regions

      2. Click the Run button to generate your chart

      Step 3: Customize Chart Appearance

      Now that we have our basic chart, let's customize it:

      1. Click the Customize tab next to the Data tab

      2. Under Chart Options:

        • Set the Bar Padding to 0.2 for better spacing

        • Toggle on Show Value to display the values on each bar

        • Set Y Axis Format to ".2s" to show values in thousands/millions with 2 significant numbers

      3. Under Colors:

        • Click on Color Scheme dropdown

        • Select "UpMetrics Blue 10" (or your preferred palette)

      4. Under X Axis:

        • Set Label Angle to 45 degrees if region names are long

        • Toggle on Label Outer Padding to add space between labels

      5. Add a meaningful title:

        • Click on the default chart title at the top

        • Change it to "2023 Sales Performance by Region"

      6. Click Run again to apply all customizations

      Step 5: Add Filters (Optional)

      Let's add a filter to make the chart interactive:

      1. In the Filters section (typically on the left side):

        • Click + Add Filter

        • Select "Date" as the column

        • Choose "Time range" as the filter type

        • Set the range to "Last 12 months" or your preferred timeframe

        • Click Apply

      2. Click Run to update the chart with the applied filter

      Step 6: Save Your Chart and Add to Dashboard

      1. Click the Save button in the top right corner

      2. In the save dialog:

        • Select "Save as"

        • Name it "Regional Sales Performance"

        • Optionally add a description

        • Choose an existing dashboard from the dropdown or create a new one

      3. Click Save to finalize

      Step 7: View Your Chart in the Dashboard

      1. Navigate to Dashboards in the main navigation

      2. Select the dashboard where you saved your chart

      3. Your bar chart should now be visible in the dashboard

      4. To edit the position or size:

        • Click Edit Dashboard
        • Drag the chart to reposition it
        • Use the corner handles to resize it
      5. Click Save when you're satisfied with the layout

      Example: Sales Trend Analysis

      Let's create a time series bar chart to analyze monthly sales trends with year-over-year comparison.

      Step 1. Create a new Chart

      1. Navigate to Advanced Analytics and create a new chart

      2. Select the "Sales Performance" data table

      3. In the visualization type selector, select Bar Chart from the available options

      4. Click Create Chart

      Step 2. Configure Your Chart

      The chart builder is divided into several panels that allow you to customize your visualization:

      Basic Configuration

      1. In the Data tab:

        • Select “Sales” (or your revenue metric) as the Metric for your Y-axis

        • Select “SUM” as the Aggregate function

        • Rename this to “Monthly Sales” by clicking the pencil icon

        • In the Time section:

          • Ensure "Order Date" is selected as Time Column

          • Set Time Grain to "month"

          • Set Time Range to "Last 2 years"

        • Select “Order By” as the Dimension for your X-axis

        • This will set your X-axis to create time-based groupings

      2. Click the Run button to generate your chart

      Step 3: Add Year-over-Year Comparison

      1. In the Data tab:

        • Add a second Dimension: "year"

        • This will create grouped bars for each month, showing different years side by side

      2. Click Run to update the chart

      Step 4: Enhance Visualization

      1. In the Customize tab:

        • Under Chart Options, adjust the Bar Width to 0.6

        • Toggle on Reduce X-axis Ticks to make the chart cleaner

      2. Under Colors:

        • Select a Color Scheme that differentiates years clearly

        • Consider using the "UpMetrics Blue 10" palette for a professional look

      3. Under X Axis:

        • Set Label Angle to 45 degrees for better readability

        • Enable Format and set to "%b" to show abbreviated month names

      4. Add an informative title like "Monthly Sales: 2-Year Comparison"

      5. Click Run to apply all customizations

      Saving and Sharing Your Bar Chart

      Saving Your Chart

      1. Click the Save button in the top right corner

      2. Choose whether to:

        • Save as a new chart

        • Overwrite an existing chart

        • Add to a dashboard

      3. Enter a name and optional description

      4. Click Save to confirm

      Adding to a Dashboard

      1. After saving your chart, navigate to your dashboard

      2. Click Edit Dashboard

      3. Select + Chart to add a chart

      4. Choose your saved bar chart from the list

      5. Position and resize the chart on your dashboard

      6. Click Save to update the dashboard

      Design Best Practices

      Color Selection

      • Use colors that align with your brand guidelines

      • Ensure sufficient contrast for accessibility

      • Limit the number of colors to avoid visual overload

      • Use color consistently across related charts

      Labeling

      • Include clear, concise titles that explain what the chart shows

      • Add descriptive axis labels

      • Use data labels when specific values are important

      • Include a legend when multiple series are displayed

      Data Integrity

      • Start your Y-axis at zero for bar charts to avoid misrepresentation

      • Consider using error bars when displaying estimated or sampled data

      • Use consistent scales when comparing multiple charts

      • Add footnotes for data sources or special calculations

      Troubleshooting Common Issues

      Chart Doesn't Display Properly

      • Verify your dataset has the expected values

      • Check that you've selected appropriate dimensions and metrics

      • Ensure you've clicked the Run button after making changes

      • Try clearing browser cache or using a different browser

      Too Many Categories

      If your bar chart has too many categories and becomes unreadable:

      • Use filters to focus on the most important categories

      • Group smaller categories into an "Other" category

      • Switch to a horizontal bar chart for better readability

      • Consider using a different visualization type for very large datasets

      Performance Issues

      If your chart is slow to render:

      • Reduce the amount of data by applying filters

      • Increase aggregation (e.g., monthly instead of daily)

      • Consider creating a virtual dataset with pre-aggregated data

      Conclusion

      Bar charts in UpMetrics Advanced Analytics offer a powerful way to visualize and understand your data. By following this guide, you now have the knowledge to create effective bar charts that communicate your data clearly and professionally.

      Remember that the best visualizations are those that help your audience quickly understand the story in your data. Experiment with different options and continue refining your charts to create compelling visual narratives.