Glide Training Logo

Excel Data Labels: How to add totals as labels to a stacked bar chart (pre-2013)

  

Written by Jane Hames

On some recent Excel 2010 training a question came up about how can the totals be shown as data labels rather than as a bar in the chart. In pre-2013 versions this is not obvious and to begin with I was stumped, but (as is often the case with software use) a bit of creative thinking and trial and error, we came up with a solution. Here’s what we did:

  1. Starting with a chart like this, we want the total bars to be removed and shown as a data label instead.
  2. totals shown as bars

  3. Right click on one of the bars respresenting the total and select Change Series Chart Type.
  4. change series type

  5. Select a Line Chart
  6. total shown as a line

  7. Click on the line and set it have Data Labels.
  8. data labels

  9. Set the line to have No Outline so that it will be invisible.
  10. set the line to have no outline

  11. Now you have a stacked column chart with the totals shown as data labels
  12. totals shown as data labels


previous post: Excel shortcut keys to save you time and frustration

next post: Remove date formatting from cells in Excel

Why choose Glide?

Our Unique Approach

Our Unique Approach

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you're looking to achieve.

View details »

Our Low Prices

Our Low Prices

We deliver all our on-site training at our customers' premises. Not only does that avoid any travel inconvenience for your team, but also it means we don't have the overheads required to maintain a dedicated training centre - and in turn we are able to pass these savings on to you.

View details »

Our Expertise

Our Expertise

Our trainers have designed and delivered IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

View details »

Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo
Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo