{"id":1690,"date":"2022-12-12T20:42:47","date_gmt":"2022-12-12T20:42:47","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1690"},"modified":"2024-01-17T21:25:09","modified_gmt":"2024-01-17T21:25:09","slug":"dumbbell-dna-chart","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/dumbbell-dna-chart\/","title":{"rendered":"How to create Dumbbell DNA Chart in Excel? (DNA Chart in Excel)"},"content":{"rendered":"<p>A Dumbbell DNA chart is a type of chart that is useful for comparing two sets of data with a before-and-after comparison. This type of chart consists of two dots or circles connected by a line, where each dot represents a data point and the line represents the difference between them. This article will provide you with a step-by-step guide on how to create a dumbbell or DNA chart in Excel.<\/p>\n<h2><strong>Uses of dumbbell DNA chart:<\/strong><\/h2>\n<ul>\n<li>Sales, income, and profits are just some of the types of information typically represented using dumbbell or DNA charts in the business and finance world. They can be used to examine the effect of a certain event, such as the release of a new product, by comparing data collected before and after the introduction.<\/li>\n<li>They can also be used to illustrate information gained from scientific studies, including the conclusions of experiments or clinical trials. Data before and after an intervention, like a new drug or treatment, can be compared using a Dumbbell or DNA chart to determine the intervention&#8217;s efficacy.<\/li>\n<li>In education, DNA or dumbbell charts are useful for monitoring development over time. They can be used to see how much of an influence an intervention like tutoring or mentorship has on a student&#8217;s grades by comparing data from before and after the intervention was implemented.<\/li>\n<\/ul>\n<h2><strong>How to create Dumbbell Chart in Excel?<\/strong><\/h2>\n<p>In order to create dumbbell or DNA chart in excel, do the following steps:<\/p>\n<ol>\n<li>Take sample data. Here we take 3 more columns for supporting calculation.<\/li>\n<\/ol>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-1691\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-1.png\" alt=\"Dunmbell DNA Chart\" width=\"575\" height=\"201\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-1.png 575w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-1-300x105.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>2. Go to the ribbon, select Insert, and select your chart type from the chart group.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1692\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-2.png\" alt=\"Dunmbell DNA Chart\" width=\"676\" height=\"146\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-2.png 676w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-2-300x65.png 300w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3. Select Chart type as Scatter.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1693\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-3.png\" alt=\"Dunmbell DNA Chart\" width=\"169\" height=\"322\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-3.png 169w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-3-157x300.png 157w\" sizes=\"(max-width: 169px) 100vw, 169px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>4. To add data in the chart, right-click on the chart and choose Select Data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1694\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-4.png\" alt=\"Dunmbell DNA Chart\" width=\"426\" height=\"390\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-4.png 426w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-4-300x275.png 300w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>5. Select Add option to add data for creating the chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1695\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-5.png\" alt=\"Dunmbell DNA Chart\" width=\"478\" height=\"278\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-5.png 478w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-5-300x174.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>6. Take the first data range values as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1696\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-6.png\" alt=\"Dunmbell DNA Chart \" width=\"518\" height=\"208\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-6.png 518w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-6-300x120.png 300w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>7. Take the second data range values as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1697\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-7.png\" alt=\"Dunmbell DNA Chart\" width=\"510\" height=\"196\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-7.png 510w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-7-300x115.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>8. The chart looks like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1698\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-8.png\" alt=\"Dunmbell DNA Chart\" width=\"513\" height=\"321\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-8.png 513w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-8-300x188.png 300w\" sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>9. For adding Legend \u2013 click on the Chart, press + bottom and check the Legend box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1699\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-9.png\" alt=\"Dunmbell DNA Chart \" width=\"575\" height=\"262\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-9.png 575w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-9-300x137.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>10. After that choose Legend Position On Top.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1700\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-10.png\" alt=\"Dunmbell DNA Chart\" width=\"612\" height=\"317\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-10.png 612w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-10-300x155.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>11. For changing the Marker size, right-click on the chart to go Format Data Series then go to the Series Option, and select Marker Option, now change the marker type and size (here 22).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1701\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-11.png\" alt=\"Dunmbell DNA Chart\" width=\"625\" height=\"356\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-11.png 625w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-11-300x171.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>12. To change the first marker fill, right-click on the marker, go to Format Data Series, choose Fill, select Solid Fill, and choose white.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1703\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-12.png\" alt=\"Dunmbell DNA Chart\" width=\"603\" height=\"457\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-12.png 603w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-12-300x227.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>13. To change the first marker border, right-click on the marker, select Format Data Series then go to the border, select Solid line, and choose your color. Change the border width to 1.5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1704\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-13.png\" alt=\"Dunmbell DNA Chart \" width=\"639\" height=\"407\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-13.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-13-300x191.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>14. To change the second marker fill, right-click on the marker to go to Format Data Series then go to the Fill, select Solid Fill and choose your color<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1705\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-14.png\" alt=\"Dunmbell DNA Chart\" width=\"614\" height=\"391\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-14.png 614w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-14-300x191.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>15. 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-1706\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-15.png\" alt=\"Dunmbell DNA Chart\" width=\"578\" height=\"264\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-15.png 578w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-15-300x137.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>16. To change the Maximum Axis for Left Axis, right-click on the chart to Format Data Series then go to the Axis Option, select Maximum and reset the range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1707\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-16.png\" alt=\"Dunmbell DNA Chart\" width=\"658\" height=\"394\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-16.png 658w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-16-300x180.png 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>17. To change the Minimum Axis for the bottom Axis, right-click on the chart to Format Data Series then go to the Axis Option, select Minimum and reset the range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1708\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-17.png\" alt=\"Dunmbell DNA Chart\" width=\"657\" height=\"376\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-17.png 657w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-17-300x172.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>18. Create a formula for the Positive error bar in sample data and copy it down to cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1709\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-18.png\" alt=\"Dunmbell DNA Chart\" width=\"432\" height=\"188\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-18.png 432w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-18-300x131.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>19. Create a formula for the Negative error bar in sample data and copy it down to cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1710\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-19.png\" alt=\"Dunmbell DNA Chart\" width=\"464\" height=\"187\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-19.png 464w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-19-300x121.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>20. Create custom Data Labels through the below formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1711\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-20.png\" alt=\"Dunmbell DNA Chart\" width=\"460\" height=\"186\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-20.png 460w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-20-300x121.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>21. To select the error bar, click on the chart then select the + button, and check the Error bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1712\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-21.png\" alt=\"Dunmbell DNA Chart\" width=\"576\" height=\"263\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-21.png 576w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-21-300x137.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>22. To select No cap in the error bar, right-click on the chart to Format error bars then go to the Horizontal error bar Option, and Select No Cap.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1713\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-22.png\" alt=\"Dunmbell DNA Chart\" width=\"543\" height=\"334\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-22.png 543w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-22-300x185.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>23. After that choose Custom range from the same place.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1714\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24.png\" alt=\"Dunmbell DNA Chart\" width=\"568\" height=\"385\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24.png 568w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24-300x203.png 300w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>24. Select the positive error bar and negative error bar data range from the sample data table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1715\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24-1.png\" alt=\"Dunmbell DNA Chart\" width=\"590\" height=\"166\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24-1.png 590w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-24-1-300x84.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>25. Remove vertical error bars from the chart. Select the bar and delete.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1716\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-25.png\" alt=\"Dunmbell DNA Chart\" width=\"420\" height=\"264\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-25.png 420w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-25-300x189.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>26. The chart looks below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1717\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-26.png\" alt=\"Dunmbell DNA Chart\" width=\"511\" height=\"318\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-26.png 511w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-26-300x187.png 300w\" sizes=\"(max-width: 511px) 100vw, 511px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>27. To give the first Data Labels (here for 2018), click on the chart then select the + button, and check the Data Labels, select More Option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1718\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-27.png\" alt=\"Dunmbell DNA Chart\" width=\"675\" height=\"334\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-27.png 675w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-27-300x148.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>28. After that select Label Option and click Value From Cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1719\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-28.png\" alt=\"Dunmbell DNA Chart \" width=\"558\" height=\"287\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-28.png 558w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-28-300x154.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>29. Select data range from sample data for the first data label (for 2019).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1720\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-29.png\" alt=\"Dunmbell DNA Chart\" width=\"599\" height=\"154\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-29.png 599w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-29-300x77.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>30. Unselect the Y value and change the data label position to the Left.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1721\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-30.png\" alt=\"Dunmbell DNA Chart\" width=\"624\" height=\"457\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-30.png 624w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-30-300x220.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>31. To give second Data Labels (here 2019), click on the chart then select the + button, and check the Data Labels, select More Option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1722\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-31.png\" alt=\"Dunmbell DNA Chart\" width=\"610\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-31.png 610w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-31-300x150.png 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>32. After that select Label Option and click Value From Cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1723\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-32.png\" alt=\"Dunmbell DNA Chart\" width=\"600\" height=\"298\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-32.png 600w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-32-300x149.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>33. Select data range from sample data for the second data label.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1724\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-33.png\" alt=\"Dunmbell DNA Chart\" width=\"469\" height=\"275\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-33.png 469w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-33-300x176.png 300w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>34. Unselect the Y value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1725\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-34.png\" alt=\"Dunmbell DNA Chart \" width=\"582\" height=\"387\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-34.png 582w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-34-300x199.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>35. The chart looks like below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1726\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-35.png\" alt=\"Dunmbell DNA Chart \" width=\"497\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-35.png 497w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dunmbell-DNA-Chart-35-300x184.png 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/p>\n<h2><strong>Application of Dumbbell Chart in Dashboard Reporting<\/strong><\/h2>\n<figure id=\"attachment_8105\" aria-describedby=\"caption-attachment-8105\" style=\"width: 659px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8105\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dumbbell-Chart-in-Excel.png\" alt=\"Data Visualization Charts and Graphs\" width=\"659\" height=\"593\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dumbbell-Chart-in-Excel.png 967w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dumbbell-Chart-in-Excel-300x270.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Dumbbell-Chart-in-Excel-768x692.png 768w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><figcaption id=\"caption-attachment-8105\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/data-visualization-charts-and-graphs\">Data Visualization Charts and Graphs<\/a><\/figcaption><\/figure>\n<p>Here are some uses of dumbbell charts in Excel in dashboard reporting:<\/p>\n<ol>\n<li><strong>Pre vs. Post Comparison<\/strong>:\n<ul>\n<li>Ideal for comparing the performance of different metrics before and after a specific event or intervention, such as sales figures before and after a marketing campaign, or performance metrics before and after a training program.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Target vs. Achievement Visualization<\/strong>:\n<ul>\n<li>Visualizes the comparison between targets set and actual achievements for different categories or periods, clearly showing where targets have been met, exceeded, or fallen short.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Year-over-Year or Periodic Change Analysis<\/strong>:\n<ul>\n<li>Compares metrics from different time periods (e.g., monthly, quarterly, yearly) to show growth, decline, or stability, providing insights into trends over time.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Product or Category Performance Comparison<\/strong>:\n<ul>\n<li>Displays side-by-side comparisons of different products or categories on specific metrics, like comparing the revenue generated by each product or customer satisfaction ratings across services.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Geographical Data Comparison<\/strong>:\n<ul>\n<li>Compares data points across different geographic regions, such as population growth, average income, or sales figures, highlighting regional variations or growth patterns.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Health or Environmental Data Monitoring<\/strong>:\n<ul>\n<li>Useful for comparing health or environmental data, such as the change in pollution levels, temperature variations, or health indicators (e.g., pre and post-vaccination infection rates) across different locations or time periods.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\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<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>A Dumbbell DNA chart is a type of chart that is useful for comparing two sets of data with a before-and-after comparison. This type of chart consists of two dots or circles connected by a line, where each dot represents a data point and the line represents the difference between them. This article will provide &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/dumbbell-dna-chart\/\"> <span class=\"screen-reader-text\">How to create Dumbbell DNA Chart in Excel? (DNA Chart in Excel)<\/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":[221],"tags":[222,223],"class_list":["post-1690","post","type-post","status-publish","format-standard","hentry","category-dumbbell-dna-chart","tag-dumbbell-dna-chart","tag-dumbbell-dna-chart-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1690","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=1690"}],"version-history":[{"count":8,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1690\/revisions"}],"predecessor-version":[{"id":8106,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1690\/revisions\/8106"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}