{"id":3045,"date":"2023-01-12T20:52:47","date_gmt":"2023-01-12T20:52:47","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3045"},"modified":"2024-01-17T16:51:05","modified_gmt":"2024-01-17T16:51:05","slug":"how-to-create-bar-chart-with-bubble-in-top","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-bar-chart-with-bubble-in-top\/","title":{"rendered":"How to Create Bar Chart with Bubble in Top?"},"content":{"rendered":"<p>Bar chart with bubble in top is a type of chart that combines the features of both a <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-bar-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">bar chart<\/a> and a line chart with the marker. They are an effective tool for displaying data in a way that is easy to understand and can provide more information than a traditional bar chart. In this article, we will provide you with a step-by-step guide on how to create a bar chart with bubbles at the top in Excel.<\/p>\n<h2><strong>Uses of bar chart with bubble:<\/strong><\/h2>\n<ul>\n<li>Bar charts with bubbles at the top are commonly used in business and finance to represent data such as market share, revenue, and profits. They can be used to compare data across different time periods or product lines and can also show additional information such as the number of units sold.<\/li>\n<li>They are also useful in scientific research to represent data such as experimental results, survey data, and demographic information. Bar charts with bubbles in the top can be used to compare data across different groups and can also show additional information such as the sample size.<\/li>\n<li>Bar charts with bubbles in the top can also be used in project management to track progress toward specific goals or milestones. They can be used to represent data such as project timelines, resource allocation, and budget expenditures and show additional information such as the percentage completion.<\/li>\n<\/ul>\n<h2><strong>How to make a bar chart with bubble in top?<\/strong><\/h2>\n<p>In order to make bar chart with bubble, do the following steps:<\/p>\n<ol>\n<li>Take sample data, here we take one more addition column for calculation.<img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-3046\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-1.png\" alt=\"Bar chart with bubble in top\" width=\"397\" height=\"288\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-1.png 397w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-1-300x218.png 300w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/li>\n<li><span style=\"font-size: 16px;\">Go to ribbon and select Insert and select your chart type from the chart group.<\/span><img decoding=\"async\" class=\"aligncenter size-full wp-image-3047\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-2.png\" alt=\"Bar chart with bubble in top\" width=\"787\" height=\"176\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-2.png 787w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-2-300x67.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-2-768x172.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/li>\n<\/ol>\n<p>3. Select your Chart type 2-D stacked column.<img decoding=\"async\" class=\"aligncenter size-full wp-image-3048\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-3.png\" alt=\"Bar chart with bubble in top\" width=\"236\" height=\"442\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-3.png 236w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-3-160x300.png 160w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/p>\n<p>4. The chart looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3049\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-4.png\" alt=\"Bar chart with bubble in top\" width=\"592\" height=\"362\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-4.png 592w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-4-300x183.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p>5. To remove Gridline, click on the chart then select the + button, and uncheck the Gridline.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3050\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-5.png\" alt=\"Bar chart with bubble in top\" width=\"682\" height=\"321\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-5.png 682w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-5-300x141.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p>6. To change the Gap width, right-click on Chart and select Format Data Series.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3051\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-6.png\" alt=\"Bar chart with bubble in top\" width=\"647\" height=\"477\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-6.png 647w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-6-300x221.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/p>\n<p>7. After selecting Format data series go to the series Option and change the Gap width to 100%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3052\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-7.png\" alt=\"Bar chart with bubble in top\" width=\"782\" height=\"367\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-7.png 782w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-7-300x141.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-7-768x360.png 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/p>\n<p>8. To change the color in the bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose your color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3053\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-8.png\" alt=\"Bar chart with bubble in top\" width=\"752\" height=\"562\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-8.png 752w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-8-300x224.png 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p>9. To add the second data series, right-click on the chart and click Select Data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3054\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-9.png\" alt=\"Bar chart with bubble in top\" width=\"656\" height=\"461\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-9.png 656w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-9-300x211.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>10. After that select Add to add new data.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3055\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-10.png\" alt=\"Bar chart with bubble in top\" width=\"681\" height=\"402\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-10.png 681w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-10-300x177.png 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>\n<p>11. Select the Series name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3056\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-11.png\" alt=\"Bar chart with bubble in top\" width=\"622\" height=\"235\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-11.png 622w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-11-300x113.png 300w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/p>\n<p>12. Select Marker range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3057\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-12.png\" alt=\"Bar chart with bubble in top\" width=\"621\" height=\"237\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-12.png 621w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-12-300x114.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<p>13. Select EDIT, shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3058\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-13.png\" alt=\"Bar chart with bubble in top\" width=\"685\" height=\"395\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-13.png 685w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-13-300x173.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/p>\n<p>14. Select product Range then select OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3059\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-14.png\" alt=\"Bar chart with bubble in top\" width=\"697\" height=\"272\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-14.png 697w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-14-300x117.png 300w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/p>\n<p>15. Select OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3060\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-15.png\" alt=\"Bar chart with bubble in top\" width=\"678\" height=\"392\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-15.png 678w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-15-300x173.png 300w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>16. For changing the Stacked chart to a line chart, Click the right button and select Change Series Chart Type.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3061\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-16.png\" alt=\"Bar chart with bubble in top\" width=\"653\" height=\"362\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-16.png 653w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-16-300x166.png 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/p>\n<p>17. Select the line change chart and click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3062\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-17.png\" alt=\"Bar chart with bubble in top\" width=\"625\" height=\"601\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-17.png 625w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-17-300x288.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>18. To remove the line from the <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-line-chart\/\" target=\"_blank\" rel=\"noopener\">line chart<\/a>, go to Format in the ribbon then select shape outline and choose No Outline.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3063\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-18.png\" alt=\"Bar chart with bubble in top\" width=\"497\" height=\"487\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-18.png 497w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-18-300x294.png 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/p>\n<p>19. After that increase the Marker size, go to Format Data Series, select Marker Options, and change the marker size to 15.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3064\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-19.png\" alt=\"Bar chart with bubble in top\" width=\"702\" height=\"382\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-19.png 702w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-19-300x163.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/p>\n<p>20. To change the Marker color, right-click on the chart and select Format Data, in Format Data Series select Marker Option then click Fill and choose your color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3065\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-20.png\" alt=\"Bar chart with bubble in top\" width=\"722\" height=\"543\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-20.png 722w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-20-300x226.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/p>\n<p>21. To give Data Labels in the chart click on your chart and select the + button to give your Data labels. Select Data labels and click on Above or any other option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3066\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-21.png\" alt=\"Bar chart with bubble in top\" width=\"728\" height=\"291\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-21.png 728w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-21-300x120.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>22. To change the Label position in the chart, right-click on the label and select Format Data Labels, in Format Data Labels select label Option then click Center.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3067\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-22.png\" alt=\"Bar chart with bubble in top\" width=\"722\" height=\"490\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-22.png 722w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-22-300x204.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>23. To change the data Labels color, go to Format in the ribbon then select Text color and choose white.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3068\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-23.png\" alt=\"Bar chart with bubble in top\" width=\"502\" height=\"493\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-23.png 502w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-23-300x295.png 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>24. To give Tick Mark on the horizontal Axis, right-click on the chart and select Format Axis, in Format Axis select Axis Option and click Outside in the Tick Marks option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3069\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-24.png\" alt=\"Bar chart with bubble in top\" width=\"757\" height=\"400\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-24.png 757w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-24-300x159.png 300w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>25. To change the Tick Marks line color, right-click on the Horizontal axis and select Format Axis, in Format Axis select Axis Option and choose a color from the Line option.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3070\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-25.png\" alt=\"Bar chart with bubble in top\" width=\"791\" height=\"527\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-25.png 791w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-25-300x200.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-25-768x512.png 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/p>\n<p>26. To remove the vertical Axis, right-click on the vertical axis and select Format Axis, in Format Axis select Axis Option and select Labels, and choose None.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3071\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-26.png\" alt=\"Bar chart with bubble in top\" width=\"695\" height=\"367\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-26.png 695w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-26-300x158.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/p>\n<p>27. To give Chart title, click on chart then select + button and check the Chart Title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3072\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-27.png\" alt=\"Bar chart with bubble in top\" width=\"692\" height=\"316\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-27.png 692w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-27-300x137.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/p>\n<p>28. The chart looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3073\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-28.png\" alt=\"Bar chart with bubble in top\" width=\"595\" height=\"367\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-28.png 595w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-in-top-28-300x185.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/p>\n<h2><strong>Application of Bar Chart with bubble on top in Dashboard Reporting<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_8101\" aria-describedby=\"caption-attachment-8101\" style=\"width: 1093px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8101\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-on-top.png\" alt=\"Quality Control Dashboard - Manufacturing Dashboard\" width=\"1093\" height=\"817\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-on-top.png 1093w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-on-top-300x224.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-on-top-1024x765.png 1024w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Bar-chart-with-bubble-on-top-768x574.png 768w\" sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><figcaption id=\"caption-attachment-8101\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/quality-control-dashboard---manufacturing-dashboard\">Quality Control Dashboard &#8211; Manufacturing Dashboard<\/a><\/figcaption><\/figure>\n<p>Here are six uses of a Bar Chart with a Bubble in Top in dashboard reporting:<\/p>\n<ol>\n<li><strong>Highlighting Maximum or Minimum Values<\/strong>:\n<ul>\n<li>Places a bubble at the top of the highest or lowest bar to draw attention to the maximum or minimum value in a data set, such as highlighting the best-selling product or the least populated region.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Combining Two Data Sets<\/strong>:\n<ul>\n<li>Uses the bar to represent one set of data (e.g., total sales) and the bubble to represent another related metric (e.g., profit margin), providing a two-dimensional view of performance metrics.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Emphasizing Data Outliers<\/strong>:\n<ul>\n<li>Places a bubble on bars that represent outlier values, making it easier to spot and analyze anomalies or exceptional data points in a dataset, such as unusually high sales in a specific month or a sudden drop in website traffic.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Indicating Trend or Change<\/strong>:\n<ul>\n<li>The bubble can represent the rate of change or trend for the data point in the bar, such as the growth rate of sales or the percentage change in customer satisfaction scores, providing a snapshot of dynamic data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Displaying Additional Categorical Data<\/strong>:\n<ul>\n<li>The bubble can hold categorical information (e.g., product rating, risk level) related to the bar it tops, offering a quick visual reference for qualitative assessment alongside quantitative measurements.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Segmenting Data Further<\/strong>:\n<ul>\n<li>For each bar, the bubble can represent a segment of the data related to the bar&#8217;s total value, such as the proportion of sales from a new product in the total sales figure, enabling a compact and informative data presentation.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>This type of chart can be particularly effective when you want to provide a clear visual emphasis on specific data points or to integrate an additional data dimension without cluttering the visual presentation. The use of bubbles draws the viewer&#8217;s attention and can convey supplementary information at a glance.<\/p>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Bar chart with bubble in top is a type of chart that combines the features of both a bar chart and a line chart with the marker. They are an effective tool for displaying data in a way that is easy to understand and can provide more information than a traditional bar chart. In this &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-bar-chart-with-bubble-in-top\/\"> <span class=\"screen-reader-text\">How to Create Bar Chart with Bubble in Top?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[372],"tags":[374,373],"class_list":["post-3045","post","type-post","status-publish","format-standard","hentry","category-bar-chart-with-bubble-in-top","tag-bar-chart-with-bubble-in-top","tag-create-bar-chart-with-bubble-in-top"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=3045"}],"version-history":[{"count":5,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3045\/revisions"}],"predecessor-version":[{"id":8102,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3045\/revisions\/8102"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=3045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=3045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=3045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}