Business intelligence blog

    What is a bullet chart and how is it useful?


    The bullet chart is useful to visually track performance against a target, displaying results in a single column. The chart can display one or many columns that can be color-coded, and it looks like a thermometer. The bullet chart was invented by data visualization specialist, Stephen Lew to enhance the gauge chart. Phocas has always offered the bullet chart in its data analytics solution because it's an effective tool to understand variance.


    The Phocas bullet chart has the following features:

    • Compact in size and it runs vertically based on the space available.
    • Multiple measures can be displayed
    • Select a single bullet chart to represent overall total or many bullets to compare regions, people or products
    • Easy to read and informative to the eye
    • The gray column typically represents a target, and the colored column represents your actual performance.  

    Check Out Our Ultimate Guide to Data Visualization Tools

    How can a bullet chart be used?

     

     

    In the video example above, the bullet chart shows at a glance, how sales results across divisions compare to the sales results of the previous year. You can quickly see what divisions are performing well and when you hover the cursor over the chart, the actual figures are displayed so there is both a visual and number view of sales side-by-side.

    In four easy steps, a bullet chart is created in Phocas data analytics to compare YTD sales by region with last year. Add another step in the data analytics solution if variance by overall result is also useful.

    To start, a period is selected, here year to date is used so the numbers line up according to the current point in time (end of October) and the months of the year that have passed (10 months).

    To compare the current period to last year, variance needs to be selected in mode. To see the variance visually, move from numbers to charts by clicking on the chart icon and to view the results in a bullet chart, you go into KPI charts and select bullet chart.

    The results show the east division has achieved 90% of sales of the previous year's total, with two months yet to run in the year. To improve the usefulness of the bullet chart, ranges with color coding similar to traffic lights can be set. This feature makes it clear which divisions are closest to target. In this example, the north division needs to work hard to meet last year’s sales and so this chart can be sent to all divisions or just the north team.

    To determine overall variance compared to last year's results, click on the use total button and three figures are displayed. a) Last year's sales b) current sales and c) variance for today is 15% or sales are at 85%.  This total figure might be useful on dashboard so click on add to dashboard.

    To learn more about bullet charts and business intelligence dashboards?  Click here to download the eGuide.

    PLACEHOLDER CTA

     

     

    Written by Phocas Software
    Successful Business Intelligence - Phocas Software
    Successful Business Intelligence - Phocas Software
    Phocas_Executive-KPIs-eBook-cover
    FEATURED EBOOK

    Top 7 KPIs and metrics for mid-market executives

    Download eBook

    Leave a reply

    Your email address will not be published. Required fields are marked *

    Related posts

    How information gives companies a competitive...
    2 MIN

    The pandemic of 2020 created a record number of new companies. A rise in entrepreneurship accompanies every downturn...

    Reduce costs with a data analytics bootcamp
    3 MIN

    There are many courses called data analytics bootcamps which teach participants the basics of working with data....

    BI stands for and other handy data terms
    5 MIN

    BI stands for 'business intelligence' but we all know wrapping your head around words, phrases and acronyms in the...

    Subscribe to our blog

    Sign up to get the latest news and insights from Phocas experts