Pill Bar with average line chart for Excel

Pill Bar with average line chart for Excel

Pill Bar with Average Line Chart for Excel

Pill Bar overview

The pill bar with average line chart is similar to a regular bar chart. Instead, with this chart, the two endpoints are round. Thus, you get what looks like a pill. Of course, as with the bar chart, this chart is shows everything in a horizontal manner. Now, with all that said, this is still 100% Excel. That is the key. Essentially, you really need to do is update the numbers and watch the chart work.

The trick

So, what is the trick? There is no real trick. However, we do some things to a regular stacked bar chart. Basically, the each pill contains five bars. An illustration of these five bars is shown below.


Microsoft Excel 2007 or higher or compatible.

Click on the button below to download this chart.


Chart library  Excel Effects home


As you may know, charts help you show data and information to your audience in a more visual manner. In addition, it tends to keep the attention of your client. So, you can also learn how to create a chart from scratch. This way, you will have a better understanding of the process for creating a chart. There are various apps that allow you to create charts. Of course, Microsoft Excel is a very popular app for working with charts. However, you can use Google SheetsApache OpenOffice, or LibreOffice to create charts. For the most part, they are compatible with Excel.