Join Nate Makdad for an in-depth discussion in this video Formatting charts, part of Creating Interactive Dashboards in Excel 2013.
- Formatting our charts with appropriate labels and scales…will make them easier to read…and allow them to stand on their own.…This will give our template the ability…for people to quickly analyze and view chart information.…So we're gonna go through a couple of steps…on ways that we can clean up our charts…and make them a little bit better to view.…And the first one that I'm going to do is resizing.…We've got some more visual space here,…now that we've kind of…put the rest of our template around it.…So what I wanna do is,…I'm gonna left-click on my first chart,…then hold down control and select my other two charts,…and then right-click and go to Size and Properties.…
And I'm gonna go ahead and change this…to 4 and then a 6,…a pretty common aspect ratio for charts.…Okay, good.…So now I'm gonna go ahead and just drag,…and I really just wanna place my charts…where I think they're gonna, you know, look best…in the overall layout.…So I'm gonna take my first chart…and just kind of line it up against the outer edge,…and then place my second chart somewhere in the middle.…
- Recognize three dimensions of a PivotTable.
- Summarize four design tips.
- Identify the two default sections for values in Excel.
- Explain how to add slicers in a single column.
- Recall the shortcut used to insert a hyperlink.
- Determine the location to look when you have an error while pasting data.