While PowerPoint 2016 for Mac itself doesnt support inserting an online video, it takes just a few steps to use an add-in that lets you insert a video from.Having covered all the basics of how to make tabular data tell a story using custom cell formatting and conditional formatting for both static tables and pivot tables, we’re now going to jump into the really fun stuff: charting data out in Excel.In the top menu bar, click ' Table ' and then ' Insert Table '. If you have recorded timings and want to use them in the video you create from your presentation. The higher the video quality, the larger the file size. Select the video quality you want: Presentation Quality, Internet Quality, or Low Quality. On the File Format menu, select the video format that you want (MP4 or MOV).I always choose Above Chart (Mac: Chart at Top). On the Mac, you’ll choose Charts > Chart Layout > Labels > Chart Title. But for others who have to try to figure out what you’re trying to communicate, it’s not always so apparent.So, in the case of the chart below, it would be insufficient to just use “Impressions” as the chart title:To add a chart title, with your chart selected, choose Chart Tools > Layout > Labels > Chart Title. When you’re the one pulling together the data, everything you’re trying to communicate is perfectly clear. Finally, select Line Color > No line (Mac: Line > Solid > Color: No Line).A common mistake I see with marketers’ charts is they’re oftentimes missing a title.
Put Fraction Into Powerpoint 2011 How To Make TabularUnder Axis Options (Mac: Scale) you can change the Major Unit setting. To rectify this, select the axis and open the formatting dialog. Excel always adds two decimal places, which you have to get rid of by clicking the Decrease Decimal icon, which is two spots to the right of the thousands separator.Alternatively, you could get into the formatting dialog and modify the number formatting there.The vertical axis in the chart above is also cluttered and overkill. Otherwise, you need to unlink it from the source in the Format Axis dialog.To add thousands separators, select the entire column and click the button with what looks like a comma in the Home tab in the Number category. The less time people have to spend interpreting your data, the more compelling it will be. It’s extraneous and noisy.If you’re trying to show percentages in the vertical axis, format them as a percent don’t format the data as decimals. I see this most commonly done with currency, where you’ll see labels like $10,000.oo, $20,000.00, $30,000.00, etc. App self control for macCreate Branded ChartsYou’re not limited to the 2,500+ themes Excel provides. To do this, select the column in the table where the data comes from, open the formatting dialog as usual, and select Number > Category: Custom, find the hyphen, and replace it with a 0.But you should explore the different themes and try branching out. You might find some very surprising options, like the ability to add text to the formatting while still keeping the value of a number.In this case, we just need to change the way 0 is formatted. You can read my post on custom number formatting to learn about how custom number formatting works. Just use 10%, 20%, etc.One final nuisance is the presentation of the 0 at the bottom of the vertical axis as a hyphen. In other words, don’t have labels like 10.00%, 20.00%, etc. Make Your Chart Title DynamicDid you know you can make your chart title update by linking it to a cell in your workbook? It’s a bit of a hack, but it’s a cool option that will make you look like a genius to your boss/client/mom.Dynamic titles are best suited for data that update on a regular basis, like daily numbers entered manually or pulled into Excel from a database.What I’m going to demonstrate is a PPC revenue report that updates daily. Crtx file in a chart templates folder. This will save your chart as a. And do that for each piece of the pie.To save it as a template on a PC, select the chart and navigate to Chart Tools > Design > Type > Save as Template.To create a new pie chart based on this template on a PC, simply click inside the data you want to chart (or select the data if it’s a partial data set), then choose Insert > Charts > Other Charts > All Chart Types > Templates (Mac: Charts > Insert Chart > Other > Templates) and select the template you want to use.On a Mac, right-click anywhere on the chart and choose Save as Template. Then reformat it by using the paint bucket under Home > Font — or pull up the formatting dialog.Assuming you have RGB values, click the drop-down menu on the paint bucket, choose More Colors > Custom > Color Model: RGB (Mac: More Colors > Color Sliders > RGB Sliders). Excel 2010 (PC) will allow you to use RGB or HSL values, whereas Excel 2011 (Mac) will let you use RGB, CMYK, or HSB values.(Since I wasn’t privy to those values, I used the Color Picker tool in the Web Developer Toolbar to identify the colors from the Toys R Us logo and then used a hex-to-RGB conversion tool to get the RGB values.)Once you have the values you need, create a chart with whatever data you want to visualize.Next, select a piece of the pie chart by clicking on the pie chart once and then on the individual piece. You can find this toggle under View > Show (Mac: Layout > View).Select a cell above the chart just to the right of the title and reference the cell with the total. You will definitely need to turn off gridlines to pull this off, but you should do that anyway. See tip #4 above for directions.Since the default fill for the chart area is white and the chart is generally displayed on a white sheet (which I recommend preserving), we’re going to change the Fill to No Fill without anyone being the wiser.To do this, select the chart and press Ctrl/Command-1, then choose Fill: No Fill (Mac: Fill > Solid > Color > No Fill). I used: “PPC Revenue for Oct:” for my title. The reason you want to format as a table is if you build a chart from a table, your chart will update automatically as you add new rows to the table.The table also automatically expands to absorb any new data you add to the table when you just enter something in a cell immediately below or to the right of a formatted table.In a cell just south of row 31 (to accommodate a full month) enter a SUM formula that captures all 31 rows — even though some will be blank if you’re only partway through the month.Add a title to your chart that indicates you have a running total. Here are the steps you’ll need to take:Make sure your data uses proper number formatting and that it’s formatted as a table, which is Excel’s version of a simple database.
0 Comments
Leave a Reply. |
AuthorJohn ArchivesCategories |