 Ond ydych chi fod y fawr yn ychelwch a ch ti halla mas hwn yn'r clwr? Yn roedd y cwm-rhyw un o'r gweithio gyda'r cyfrifiad Aberthach o'r ddau, a'i hynny'r gweithio'r cyfrifiad Merthyr ac yn ystod o'r mult yw LED o'r cyfrifiad. Yn credu'r gweithio yma'r ddurs diddorol a'r hyffordd yng Nōn yn awd, maen nhw'n argymell napeth gael eu cyfrifiad Cymrae i'r hyn newydd, mae gan hynny'n adeilad ymyl yma'n gwciffol o'r cyfrifiad. gyda'r idea o'r ysgolion sydd ymddi'r cwpio'r cyffredin hwn. Mae ddangos, mae'n meddwl i'r gweithio arno, a roedd y gweithio'r gweithio'r gweithio i'r lliwysau ac mae'r ffordd i'r wladau bobwyr. Yn cael ei ddweud hynny i ddodd yn fwrdd. First of all, mae'r ffordd i'r gweithio'r gweithio. Mae'n gwneud o'r ddodd yn fwyaf, rydyn ni'n mynd i'r ffordd i'r ddodd. i'w ddweud o ddweud. A i ddweud y ydw i'w ddweud yma, ddim yn golygu rhan o rei, a rhai o rhan o cwmau, rhai o rhan o cwmau, rhai o rhan o cwmau, rhai o cwmau, rhai o rhan o cwmau, yn cael ei wneud yn 0 i 70 a chydwn i'n mynd i'n gweithio. Rydw i'n dduodd. Felly, rydw i'n ddweud yma. So dyna'r ddweud yma, mae dyna'r ddweud yma, mae rydw i'n ei ddweud, rydw i'n rydw i'n mynd i'n ddweud. Felly mae'n gweithio'n gweithio. First thing I need to do is have it blocked in some kind of way. So I can do this as the round function and you can see if I round it to zero decimal places it gives me a whole number but actually I want it more rounded than that so I'm going to divide that by 10 first. So there are various ways of doing that but it gets you to here. You could use m round for instance to round it to a multiple that might help. Now once I've got some blocked data like this I'm going to insert myself a bar chart specifically kind of a stacked one and if we have a look at what's happening here when I refresh the data it's all locked off to one unit at a time so that's pretty good so far. Now what else? I want to add these top halves. They're about half high and some of them glow and some don't so I want a standard top and I want a glowing top and these are all going to be 0.5 each so 0.5 everywhere there. Now if I select my chart and drag this across there we go I've added my the top halves. I'm just going to say select data I've done it in such a way that it's now automatically labelled these sequences so that's very useful. Now the final one that I want is background because this is not just a background this is actually another chart object in the back so this is all going to be 8 high and one thing to notice you could dynamically set that you could change it to a particular value kind of doesn't matter so I'm going to add that as well and you can see it's stacked on the top which is not where we want it so I'm just going to come up to chart design change chart type and come down to combo it's really powerful for doing really weird things in this software keep it as cluster column, stack column sorry not clustered and I'm going to stick everything else on the secondary axis apart from the background and the reason you do that is if you do it the other way around the background with one would render above so you don't really want you don't really want that there you want it to be rendered like that so now we have our background at the top now one thing you probably notice is a what's that yellow bit doing there is this sort of bit off scale so what I'm going to do is override the the axes to make sure that the maximum is always 8 so this is where maybe some of the dynamics becomes a little bit more tricky I'm just going to make sure that this is always 8 changes to a different number and then reset it back to 8 it tends to do there so that's overridden it's now no longer automatic and you can kind of see what's going to happen here every time we refresh the data it's kind of locked to one thing but we've got these two tops still appearing so let's add in some dynamics to change that so I'm going to get rid of this for now I know that it's there I want to replace it with an if statement I only want this to appear if a particular condition is met so the logical test I'm going to use rank and specifically rank eq and the number I want is this column b2 with the hash to select all of it the reference is going to be that array so this is going to be taken as kind of a fixed array that's going to be then spilled down and if that is equal to one if it's the top to rank one I want it to read as 0.5 else blank and there you go we can see these are seven those are clear the highest number here we've got 0.5 here I'm going to copy that entire formula pasted in here and just simply swap the true and false statements around so a value if that is true is now blank else 0.5 and that will spill down once I've deleted those so you can now see the highest one has this grief box here the rest orange great so we are now at the point where this is sliding up and down and the highest one is being conditionally formatted for us the rest is just formatting so we'll do kind of the formatting now so first thing I'm going to do is just get rid of the grid lines it tends to help I can do something with the axes later but I'm not going to cover that that's just personal choice first thing format with the entire chart selected I'm going to change that background to black this is what I had it on originally I'm also going to select my background right click and format the data series and the first thing you see under the settings is gap width change that to 0% so that means the gap between it is now zero if I select my blue thing here I can change the same thing so now what we can see is we've basically got um that up and down motion but it's all blocked off so we're going to make these shaped right for here insert illustrations I'm going to pick my rounded rectangle I'm going to make this quite large and then I'm going to round it off to a particular size actually I'm going to make about two centimeters so under shape format override the size to be exactly two so I kind of know that it's standard now my shape fill for this is going to be quite a dark blue and the outline is going to be black uh it doesn't matter if the outline is thick or thin that's kind of personal taste select it control c to copy and then select this background paste it back in now you see it's kind of stretched it and if you were to zoom in and have a look at this it looks a bit pixelated and that is because this is always pasted in as an image that's kind of an important thing to kind of bear in mind it kind of fixes it as an image and pastes it in it's no longer an object that you can edit so would that in mind if you do something like this keep your original to kind of make some edits to afterwards so i'm going to keep that for now okay so fix this right on the background right click format the data series and under the fill options I've got picture texture fill selected because that's what this is and we have options down here to stretch your stack or stack and scale and I'm going to select stack and scale I'm going to scale it with one unit per picture so that's what that option is down there close that now you can see it's kind of square maybe you have to do a little bit of adjusting to make it look square but you kind of have to eyeball that but pretty good for now so my next bit I'm going to copy this again and make another copy so this I'm going to then change to maybe 1.9 1.9 so it's slightly smaller so I'll layer that actually make it even smaller than that I'll go for 1.7 make it quite quite small and here I'm going to get rid of the outline no outline fill slightly brighter blue yeah it doesn't really matter this is all this personality is find the color scheme and stick with it and then select both of them align center align middle right click and group so now this is going to be the tile that goes here and one thing we can also do is if we select the one on the back so once it's grouped you can still select the sub objects just click in there I'm going to get rid of the outline and actually get rid of the fill as well so no outline to that either so now we've got a slightly smaller one that will fit over the top now of a control C that and control V to paste it onto there ah I've now pasted it in you can see there's this transparent bit so this is still scaled to the same size as this other block but the part of the background is transparent so it means if I want to change this to say green if I control C control V that into there keeps the same settings with the scaling but it's changed the color and I don't need to change the background of the the lit up one anymore so as before right click format series and then stack and scale one unit per picture so now we've got these lights kind of flicking on and off depending on how far up it's going so next bit I'm going to create a new version yet again exactly the same size as before and change this to lighter so shape fill I'll make that the the lighter blue and I'm going to also change the height this is why it was useful to manually set this to a random brolia to one there you go it's now half the height you could paste it in and scale it down but that'll change those rounded corners slightly so just going to zoom in to make sure this is really visible um you notice when this is scaled down by half the rounded corners of half so I'm going to take the yellow tag and drag it just a little bit to the right now the rounded corners kind of match it would be nice if this was proper vector graphic software and maybe you could use use a proper image editor like inkscape or something to create these things you can just paste them in afterwards but you know this is what we've got to deal with now so I'm going to control see that paste it in here and you can see it now kind of matches and finally I'm going to change this to the the lightest possible setting control c control v so the top ones are now quite bright select that format and add a bit of a glow as well well we can make that better later by editing it but now that's the basics of it we've got some conditionally formatted bits highlighting at the top and we've also got some other lights coming on and off so hopefully that gives you some idea of how to do some more kind of dynamic interesting infographics one last thing before we go how do you add the data labels to it because that was on here there's data labels at the top if you add data labels directly to this you do not get a lot of control about where they appear you can kind of push them up and down and so on but not a lot of control all right so I want it to appear above so I'm going to hack that in kind of manually by this I'm going to put in label make it 0.5 high drag that all the way down and then I'm going to put this here so I'm going to add this extra bit and format that shape fill none so that it's completely blank now add a data label to just that series and have I changed my text fill to white you can kind of see it now that all just says 0.5 because they're 0.5 high so if I right click and format the data label I'm just going to select value from cells I'm going to put my original data in get rid of the value there and the shore leader lines now I've just got the original number but it's carrying all the decimal places so I'm just going to drag that down a little bit and the number of decimal places here will pipe across to here finally maybe set it to a neat font is maybe the the OCR1 or Daytona is quite good for that kind of thing let's drop it down maybe add a bit of a text glow to that yeah that's that's lovely and cheesy putting that on no and there we're done we start refreshing that we get that dynamic effect the numbers pipe across and everything we could easily stick a different thing on there using the same trick here if we put what is the rank equal to maybe we can conditionally format that by changing number but that's it