Hello, everybody, welcome back to the third dashboard. In this video, we will see how to create a spider web chart based on the experience needed and the average salary given out. So the experience is on Excel. So your average salary that you'll be getting is somewhere around 541,918. So that's for the entire world for all the groups, but if it is specific for HR, then it gets down to somewhere around 517 517,000, approximately. And so that's what I've done here is I've created two pivot tables, one which actually gives the data for the whole thing.

And the second one, it gives the data from which the user selects over here. So if the user selects HR automatically the second pivot updates the data for HR, it's logic is the same. I've used the macro that we have done for the previous one. So now, this time The name for pivot is not pivot one it's rather pivot three, the rest job title and concept remains the same and yes, but obviously the sheet name is also different. And once that is done I do need require a table format for my chart to get prepared. So I've used normal references that is equal to sell because this will not be different over here I have used a V lookup to get the answers for the unique experience.

And in this table my may increase and decrease as well as the parameters say for example for HR freshers are not being recruited. So here there will not be a refresher. So I've written zero and I've used an IF error to substitute all the errors with zero. Once this data is done, simply select all the parameters and come to an insert. Under charts, we can select spiderweb we have the spiderweb in case the numbers are too big to be shown, we can actually divide this variable with one 1000 to make it simpler, I'll just drag it down. So this data now we see is based on under 1000.

So there it is, that makes it a bit easier data for us to see. And we do not require that so we'll keep it as it is or the way it was. Here the data is ready. Now I wish to have the title a bit dynamic, like it should be average for the world. But this is for the job title that will be selected by the user. But the problem is it cannot be dynamic until unless it is the formulas and we cannot write in a formula in the title.

So what we do is we put in a formula into a cell and then we select the header. That is chart title under the formula bar. Now for the selection, just keep the cursor in equals to refer to that cell and press enter and automatically it will directly take the data from the cell and place it to the left. So I'll align the heading to the right And I'll ban the chart a little bit, as we know that we do have the data. So by using the settings, like, say for example, I do not want the average to be the main focus, so I'll just adjust the formatting data type. And again, I'll do Sorry, I'll go into the fill line settings, make it a solid line, make it automatic, let it be automatic, whether I'll choose a solid line and a little bit of light oranges with your dotted line.

That should give an appropriate look and average feel. And then I'll also change the pointers. So I'll go to the marker and currently does not have a pointer marker. So I'll just keep it automatics or here, I'll just select marker then I'll choose circle as my mark But the color is different. So set the color back to its color all gray. And that should do the trick and small minor modification.

So just done it for the borders, that is the fill color also has to be adjusted. Yeah, there it is. So that's the average and that's the actual. So I'll complete the dashboard. And I'll copy paste this chart into the dashboard, and we'll complete the dashboard and we'll get back to you. Until then keep practicing and keep trying