Hello everybody, welcome back to dashboard. In this video, we will be bringing all the charts that we have created into one sheet and making a final dashboard. So let's see how that's done. So I'll be creating a blank sheet, and I'll be naming it dashboard. And I'll be going to each and every sheet and copying the charts only the charts and paste those into the dashboard, something like this. I'll be selecting the first one Ctrl C, coming back to the dashboard, click on the sheet anywhere here and paste it and then I'll do the same with the others but before that I'll just close the panel and rearrange and align the chart.
So here's a little trick that you can use for this when I'm resizing the chart I'll be holding down the Alt key and this will snap the chart to the cells here on the worksheet. And you can see that gives us a very clean and finished look. Once we are done with that The data. Once done, I'll go to the second copy it. Just remember when you're pasting the rest of the charts, do not click on your previous chart or else you'll paste it and it overlaps the existing chart, and then you won't see them both. So I'll just click here below and paste it will just take a minute and rearrange and align these and then I'll get right back.
Okay, so I'm done with all three charts. So just arrange them as per my needs. And now to give it a better look, I'll select one of the frames and go to formatting and apply a border, which will give us the same look and I'll use f4. That is repeat the previous task while keeping the cursor on each chart. Now as we can see, we have a clean border. Now to keep all of these charts together, I'll group them so to do so first, I'll select all three charts, and using the Ctrl Shift key, then right click none of the group opposition group it so That when I move all three charts will move together and in the same order that I've placed them.
Next we will be adding controls to control these charts. I'll be covering that in the next video. Till then keep practicing. See you in the next video. Thank you