I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know. It’s going to be a long series — but by the time we’re finished, you’ll be able to create dashboards that excel in both form and function. (Editor’s note: This popular series continues on Marketing Land with!) Why Use Combination Charts? The first skill we’re going to focus on to that end is how to create a combination chart.

Formatting chart elements in Excel 2011 for Mac You have your choice of using the formatting tools on the three Ribbon tabs, or you can display a dialog by clicking the Format Selection button. The formatting options work the same in charts as for other objects. When you make charts in Office 2011 for Mac, you find a brand-new set of Chart tabs on the Ribbon that guide you with the latest Microsoft charting technology. If you have some data to chart, by all means use it as you go through these examples. A spreadsheet expert who is a master at Excel and Google Sheets. This tutorial covers the steps needed to create and format the pie chart shown in the image above. The chart shows data related to the sale of cookies for 2013. The chart displays both the total sales amount for each type of cookie. I already created my pie chart. I choose data labels and I click it but for some reason, I got an 'error' page message to send to microsoft and the application automatically closed off.

Adobe after effects cc 2017 free download with crack for mac. Another essential feature is set up in Consequences Project Animal formerly referred to as Character Animator of Adobes. You may also download the Adobe After Effects CC 2017 Features: • Can produce compelling visual effects.

When I took, in my dissertation, Google Analytics evangelist Avinash Kaushik asked me why I didn’t show visits and bounce rate together in the same chart. (Disclosure: I am not affiliated with MarketMotive in any way.) It’s embarrassing to admit this now, but I had no idea how to do that — or that you even could combine totally different metrics like that. But now, I use them all the time. The reason is that they give you the ability to demonstrate data trends visually. (So thanks, Avinash!) Some classic metrics I use frequently in combination charts are: • Year-over-year data • Visits vs. Bounce rate • Revenue vs. Conversion rate • Campaign cost vs.

Conversions Download The Excel Doc If you’d like to follow along, feel free to I pulled all my screenshots from. How To Create A Combination Chart Step 1: Have a dataset with at least the two values you want to chart. (I also always.) Step 2: Click any cell inside your dataset and go to Insert > Charts > Insert Column Charts > Clustered Column (in 2013 on the PC) or Charts > Column > Clustered Column (in 2011 on Mac).

With my dataset, I’m just going to select the Visits and Revenue columns since I have an extra column for conversion rate. Click for larger image Step 3: Clean up your chart with the techniques I describe in this post on. I cleaned mine up using several of the techniques I described in that post: • Removed gridlines • Thinned out the vertical axis • Added an intuitive title • Removed the tick marks in the horizontal axis • Changed the default column colors to match my branding by selecting one of the columns in the series and choosing my new color using the Fill Color icon (under Home > Font for both versions) All of these options are accessible to you by simply pressing Ctrl-1/Command-1 (PC/Mac). Click for larger image Adding A Secondary Axis Let’s say we want to also add conversion rate to the chart. I changed the Revenue series back to a column chart to decrease chart junk.

One super cool trick to adding a new data series to a chart you’ve already created is to just select the column, copy it, select the entire chart (you’ll see the whole chart outlined), and then paste it in. It won’t look amazing because we’re pasting in a value that’s less than one. But then, all you have to do if you’re following along with the download is: with the chart selected, choose the new series by going to Chart Tools > Format tab > Current Selection > Series “Conversion Rate” (2011: Charts tab > Format tab > Current Selection > Series “Conversion Rate). To change the chart type to a line chart, I’ll break out the processes for 2013 and 2011 separately since the steps for the Mac are so different. 2013 (PC): With the Conversion Rate series selected, choose Design tab > Type > Change Chart Type. Then, in the Change Chart Type dialog, set Conversion Rate to Line from the drop-down.

This is a Microsoft product, however, so it should be no surprise that there’s a way to tweak and customize it to what you prefer rather than just being stuck with the newest, fancy way to show revisions and tweaks to your document. A red line through a word to show it was deleted, the word in blue to show it was added, it was all easy and made sense. Track changes in ms word. As someone who works with a lot of different documents, I’m with you in preferring the “old style” revision display in Microsoft Word for Mac. To start out, here’s what the newer, modern revision tracking looks like in Microsoft Word for Mac: Yeah, I’m not a big fan of this either.