ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Create a Bullet Chart in Excel

Updated on April 13, 2011

Bullet charts are a progression from gauges and thermometer charts. Bullet charts feature a primary measure such as a sales total and compares it against other values such as a target.

They can also be displayed in qualitative ranges such as poor, average, good and great. Or maybe using previous sales totals like the example used in this article. They provide a lot of information in a small uncluttered graph making them perfect for dashboard sheets.

Let's look at creating a bullet chart from a range of data showing the sales of different spices. There is a target value, last year's sales and this year's sales.

Bullet chart data range
Bullet chart data range
Inserted stacked column chart
Inserted stacked column chart

Create the Initial Column Chart

  1. Select the data range that you want to use
  2. Click the Insert tab on the Ribbon
  3. Click the Column Chart button and select the Stacked Column

Using a secondary axis
Using a secondary axis

Format the Target Series

  1. Right click on the Target series and select Format Data Series from the shortcut menu
  2. Select the Secondary Axis option from the Series Options category
  3. Click the Close button
  4. Select the Secondary Vertical Axis and press the Delete key to remove it from the chart
  5. Right click on the Target data series and select Change Series Chart Type
  6. Click on Line and then select the Line with Markers from the Change Chart Type dialogue box and click Ok
  7. Right click on the Target data series and select Format Data Series
  8. Select the Line Color category and click the No Line option
  9. Select the Marker Options category and click the Built-in option
  10. Click the Type drop list arrow and choose the line marker
  11. Click in the Size drop list arrow and enter 14
  12. Click the Close button

Change the gap width of a column in a bullet chart
Change the gap width of a column in a bullet chart

Format the Sales Series

  1. Right click the Sales data series and select Format Data Series
  2. Change the Gap Width to 300%

Completed bullet chart in Excel
Completed bullet chart in Excel

The finished bullet chart uses a dash marker to indicate the target value. The number of sales are shown inside a column representing last years sales.

The finished product is a compact graph that can fit into any dashboard that shows how this years sales compare to last years, and the target set at the start of the year.

New Guestbook

    0 of 8192 characters used
    Post Comment

    • almurray lm profile imageAUTHOR

      almurray lm 

      7 years ago

      @ArizonaHydroFuel: The charts in the lens are added by taking a screenshot of it in Excel and then inserting it into a text module. There is not much scope for manipulating its size.

    • profile image

      ArizonaHydroFuel 

      7 years ago

      Hi -- Like your lens! I'm building a new lens and need to post a legible excel chart, maybe more than one. The only way I've been able to manage is to photograph the printed chart and post it as a gif file in the text module. I'm hoping there's a better way! Can you help? Also, being able to maximize or at least manipulate the size of the chart within the module would be nice.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)