Locked lesson.
About this lesson
In this lesson, you'll learn how to add Worksheets to your Dashboard and position them.
Exercise files
Download this lesson’s related exercise files.
31 - Adding Sheets To Dashboard and Positioning Them.docx57.4 KB 31 - Adding Sheets To Dashboard and Positioning Them SOLUTION.docx
56 KB
Quick reference
Adding Sheets To Dashboard and Positioning Them
In this lesson, you'll learn how to add Worksheets to your Dashboard and position them.
When to use
Use this every time you create a Dashboard.
Instructions
Once you've created and resized your dashboard, drag whichever worksheets you'd like from the "Sheets" tab on the left side of the Dashboard Screen.
Position them however you'd like by dragging and dropping the Worksheets on the Dashboard screen.
Hints & tips
- Add worksheets to your dashboard by dragging and dropping them from the left side of the screen.
- Once you add the worksheets, you'll have to drag and drop and play around with positioning them on the Dashboard screen.
- 00:03 Okay, so we've created our dashboard,
- 00:06 we've got our things set up here, we've got it resized to the size we want.
- 00:10 Now, how do we actually add stuff to it?
- 00:12 Well, we can use any of these visualizations that we've created
- 00:16 over here inside of our dashboard.
- 00:18 And we use them just by coming over to the sheets column here, and
- 00:22 if we hover over these, each one, we can see what we've got.
- 00:25 So you can see we're just showing one little bar there, so
- 00:28 I'm going to come back over here, let's grab a good one here.
- 00:34 All right, AM FOXHOUND and that looks pretty good, same thing,
- 00:37 I'm going to go over here to my Dog Breed, the other one.
- 00:39 And let's grab AM FOXHOUND for this one or
- 00:42 maybe we'll change this to ESKIMO DOG or BEAGLE.
- 00:46 All right, so okay, we've got our data here, and we can come over here and
- 00:50 we can, okay, it looks a little different.
- 00:53 Now, but either way, in order to use these, we just grab each of these and
- 00:57 then hold your mouse button down and then just drag it over here.
- 01:00 And you'll notice the whole size of this turns dark gray, right,
- 01:04 as I pull it in there.
- 01:06 And you might be thinking, well, we don't want just this one in here,
- 01:09 it took up the whole screen.
- 01:11 Well, it just sort of does that by default, you can come over here and
- 01:15 click this and do Fit, and you can sort of change it.
- 01:18 Right here, it's an entire view, we could change this to standard,
- 01:22 it kind of resizes.
- 01:24 We don't really need to do that though, because I put it back to Entire View,
- 01:27 because when we add the next thing, it will sort of resize automatically.
- 01:31 So to do that, let's grab this next guy and
- 01:33 I'm going to hold down my mouse button and drag this over.
- 01:36 And you could see sort of gray areas highlight, and
- 01:40 this is sort of suggesting where this might go.
- 01:43 So we can have them side by side, we can have one on top of the other.
- 01:46 We can have it over here, we can have it down there.
- 01:49 So you could see,
- 01:50 just sort of move your mouse around and position this wherever you want.
- 01:53 So I'm just going to put it right here and now,
- 01:56 we've got them side by side, very cool.
- 01:59 And you'll notice, again, our little menu guys are still here,
- 02:04 and we can move these around too, maybe we will in a bit.
- 02:08 But we can still toggle these things and they still work,
- 02:12 right, so very cool, right?
- 02:14 And so that's a lot of fun, so I just come through here and grab all your guys.
- 02:19 So again you could see now, it's saying hey,
- 02:21 do you want to put them right next to each other?
- 02:24 These guys are really small, or we can grab this and move it.
- 02:30 Right, so I'm going to pull this out and do this again, so here,
- 02:34 we can do like that.
- 02:35 We can have one on top of another, that's kind of cool, maybe we'll put that here.
- 02:39 We can put it down here, we can put it up there, just sort of move around and see
- 02:44 the different options that are available and just sort of have some fun with this.
- 02:48 Put it right here now, this is very small, because over here, it's very small, right?
- 02:53 But we can resize this if we want, same way,
- 02:56 we did it earlier just by dragging this guy over and doing the same thing.
- 03:01 It's a little tricky to get hold of it, there we go, and
- 03:04 you can play around with that.
- 03:07 And that's it, that looks good, and so, now, we finally got this dog name one.
- 03:13 Let's see, let's put this guy right here,
- 03:16 maybe these two graphs should go side by side.
- 03:19 So, you can position these things however you want,
- 03:22 just as easy to move them around after you've already positioned them by
- 03:25 grabbing this little notch thing here at the top.
- 03:27 And you could see there's an arrow thing that appears, that's the move thing.
- 03:33 So you just hold your mouse button down and then just drag it wherever you want.
- 03:36 So, just as easy to create a visualization and man, this took like a minute,
- 03:41 and we've already got something that's looking pretty good.
- 03:45 And we can play around with it, it still moves, very cool and
- 03:49 likewise we can grab these and pull them to different areas.
- 03:54 Now, if we want to move this down because it goes with this one or whatever,
- 03:58 we can do that, we can resize them.
- 04:00 We click this guy to toggle different things and
- 04:02 play around with that, it's very cool.
- 04:04 So you'll notice this is highlighted and if I click on this, this is highlighted.
- 04:10 To get out of that, just come over here and just click anywhere else and
- 04:13 that all disappears.
- 04:13 And so you have, a more visually pleasing thing and it's very cool.
- 04:17 So we're going to get into this stuff in more detail going forward in the next
- 04:21 few videos.
- 04:21 But right off the bat, very quick and easy way to make a dashboard and really,
- 04:25 really neat.
- 04:26 So in the next video, we'll look at redefining a dashboard.
Lesson notes are only available for subscribers.