hi guys this is Mark Davis at Optimum technology transfer welcome back to you all in this video we're going to take a quick look at creating par charts in Excel there's an example of a Paro chart here on this worksheet so uh I've taken some sample data and I created this Paro chart based uh upon it effectively a paral chart is a sorted um column chart so so what have we got here I've got a list of various European capitals and for each of those Capital Cities I have got a a sales figure yeah so what I'd like to do is I'd like to At a Glance be able to determine very very quickly uh which particular Capital City contributed the greatest um sales figure to the total sales for those various European um cities for example so a par chart is a a perfect way of quickly visualizing the data I'm going to start completely from scratch prove exactly how easy it is to create one of these things in Excel 2016 I'll delete my original delete the original Paro chart myself C pointer is somewhere in the data somewhere in my sample data really doesn't matter where click insert in the middle of the insert ribbon we've got our charts group uh click on the drop down for insert statistic chart and click and select Paro as it says from the tool tip there let me just move back onto it yeah what does a Paro chart do uh shows the relative proportion of each factor to the total so Prague Rome and so on uh down through to London show the most significant factors in the data again quickly easily visualize your data click and select reposition and uh and and resize and then start getting into the tweaks that uh I think will help uh the visualization of this particular chart so I'm going to remove first of all something very very simple indeed I'm going to remove the grid lines for example what I'm then going to do using the chart Styles button is I am going to select a different style what I'm also going to do while I'm here is Click color and I'm going to choose a monochromatic kind of color scheme that we've got there let me just click away so we can see what it looks like so far a few other little changes that you might choose to make um I'm not so keen on my my bars being so close together so what I'm going to do is I'm going to right click over one of the bars choose click format data series from the context menu and I'm going to up the Gap width to let have look at 25% 25% yeah looking good maybe just a little bit more maybe um that's 30% tab off that to have a look at the effect close down the panel of the pane on the right hand side of the moment and click away yeah looking good uh potentially your line that's a separate element um of the paral chart itself so the paral chart is kind of combin composed of two things the bars kind of from left to right from highest to lowest and also then a a percentage uh which what percentage kind of contribution they make to the total yeah from Prague to London for example yeah so that the the line and the um and the bars I'd like to make the pero line maybe a little bit different as far as the color is concerned so I'm going to make it white and I'm going to make it a little bit heavier a little bit thicker a little bit wider close down the pane or the panel and just click away one more thing I'm going to do of course the default chart title is literally chart title I'm going to change that so I'll highlight it and we can call it something like let's say uh sales data by city for example click away and there is a Paro chart in Excel 2016 that's it for me guys uh do search Optimum technology transfer for further videos that I've created let say that's that's it for me now goodbye and take care bye-bye