Join Dennis Taylor for an in-depth discussion in this video Formatting picture styles, part of Excel for Mac 2016: Advanced Formatting Techniques.
- [Teacher] We're looking at the workbook Chapter 9, Pictures. And the first worksheet is called PictureStyles. And you'll see three different images here. Over on the left-hand side below the numbers, as I click here, notice that what happens in the ribbon menu system, Picture Format appears with lots of tools for formatting that particular object. There's a picture in the middle, and as I click there, that same Picture Format tab remains. But note, if I click outside of the picture, disappears. What happens if we click on the chart to the right? That activates some special tabs as well, and there's a Format tab there, but not a Picture Format, so some different choices here.
Now, what if we've reached the point where this data is no longer changing? It's static, as they say in accounting circles sometimes, the numbers have been put to bed. What we might want to do here is to allow more formatting features for this chart here. Now, you can convert a chart into a picture, and then it would have some of those same capabilities that we have with the picture to the left, and also with that logo on the lower left corner. Now, once we do this, however, if those numbers were to change, the chart image, the picture we're about to create, will no longer be tied to the data.
So all you need to do is to right-click in the chart area of the chart itself, Copy, and either off to the right or down below makes no difference, we'll simply, by way of the Home tab, choose the drop arrow, next to Paste, and choose Paste as Picture. Now, to the right there, we do have a picture of the chart. It is no longer tied to the data. Let's say we don't need this chart anymore, the actual chart that is associated with the data, click there, press Delete, and move this over.
And, now, notice, we see Picture Format. So all three of these, the chart that we've converted into a picture, the picture itself and that logo off to the left, what they all have in common is similar formatting tools available by way of the Picture Format tab in the ribbon. So let's click the logo first and show how we could consider some different picture styles. Lots of choices here. Now, a lot of companies have hard and fast rules about what you might be able to do with the logo, so we wanna be a little bit careful here. We probably would not want to clip off the edges like this, or maybe, even tilt it, but adding a shadow, something like what we see up here on this image might be appropriate.
A drop shadow gives it a little more emphasis. Let's click on the picture in the middle and consider some options here. Now, here, with the picture, we can do a lot with it. We could put it inside of an oval, maybe that's a certain look that we want. We've got lots of choices here, 28 different choices here, some are more interesting perhaps than others, maybe you just wanna tilt it, so you've got a certain special effect in mind. And there are tons of other options as well, too. And the same thing with this chart over here. And remember, this is not really a chart anymore, it's a picture of a chart.
And just to point out again the idea that this is no longer linked to the data. If I happen to change that January entry, it's currently 84, if I make that be 200, and it's only gonna be a temporary change, but you would expect to see that react if it were chart as soon as I press Return here. Nothing happens in that chart picture at all. Remember, that was as if we took a picture of the previous chart with the data that was there. So I'm gonna undo that with Command Z. Of course, the picture will not react. So, here, too, as we click that chart, go to the Picture Format tab in the ribbon.
We could also make some changes here in terms of how we want this to be displayed. And at different times, you wanna just explore here, consider some different options, maybe for presentation purposes, you have a certain look in mind. Let's of choices out here. So we can work with all these in the same kind of way, all available by way of the options that we see on the Picture Format tab in the ribbon.
- Adjusting fonts, borders, and cell colors
- Aligning text
- Controlling numeric formatting
- Building custom numeric and date formats
- Creating value-based conditional formatting
- Working with tables
- Using styles and themes
- Adjusting row, column, and sheet sizes
- Outlining data
- Adding and formatting images
- Using specialized power formatting techniques