To add a trendline, control click on a data point or go to the Chart menu and select “Add. Enter the title for your chart and the labels for the. Step 1: Click anywhere on the chart that you want to add a title, and then the Chart Tools is active on Ribbon. Step 2: Click the Chart Titles button in Labels group under Layout Tab. Step 3: Select one of two options from the drop down list: Centered Overlay Title: this option will overlay centered title on chart without resizing chart. Having covered all the basics of how to make tabular data tell a story using and for both and we’re now going to jump into the really fun stuff: charting data out in Excel. I’m not going to cover the basics of creating charts in this post. If you want a primer, you can find. Remove Noise From Your Chart’s Background When you’re presenting data, it’s very important to reduce the noise and hone in on actionable signals. If you have read just about anything I’ve written about Excel, you’ll know I loathe gridlines in tables. And yet, until I viewed, I was blissfully oblivious to gridlines in charts. But then, they cause my eye to stumble, too. And that’s the problem with noise: it distracts you from the essential stuff. Gridlines are super easy to get rid of. First, remember the formatting trick I mention in all of my posts: if you want to format anything in Excel (in a chart or table) just select it and press Ctrl-1 (Mac: Command-1) to open the formatting dialog specific to that item. In this case, you’ll just want to select one of the gridlines in your chart (anyone but the top one, which selects the entire plot area) and then open the formatting options. Finally, select Line Color > No line (Mac: Line > Solid > Color: No Line). Click for larger image. Move The Legend I don’t know why Excel positions the legend to the right of a chart by default. Pinochle app for mac. In most cases, it’s terribly awkward. I prefer to move the legend to the top or bottom of a chart. I tend to put the legend above more than below, but I’ll put it below if there’s too much going on at the top, or sometimes, with a pie chart. To move it, just pull up the formatting option (you should know how by now!) and choose the position from Legend Options category, which is called Placement on a Mac. With the legend still selected, I usually bump the font up to 12 as well. You don’t have to select the text, just the box. You be the judge which looks better 3. Delete Legends With One Data Series If you’re only showing one metric on a chart, there’s no reason to keep the legend that Excel throws in there. Just make sure you include the metric you’re showing in the chart title. Click for larger image. Add A Descriptive Title A common mistake I see with marketers’ charts is they’re oftentimes missing a title. When you’re the one pulling together the data, everything you’re trying to communicate is perfectly clear. 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. On the Mac, you’ll choose Charts > Chart Layout > Labels > Chart Title. I always choose Above Chart (Mac: Chart at Top). Sort Your Data Before Charting This one is actually a big deal to me. Charts that are spawned from unsorted data are, in my opinion, much more difficult to read and interpret. If you’re showing something sequential, like visits per day over a period of a month or revenue per month over a period of a year, then ordering your data chronologically makes the most sense. In the absence of a dominant sort pattern like that, I’m of the opinion that data should be ordered and presented in descending order to put the most significant data first. If you look at the data in the chart immediately below, I think you’ll agree that your eyes have to dart back and forth to sort the channels by revenue. ![]() However, in the chart below, which is sorted in descending order, it’s easy to sort and interpret because it’s basically done for you. This is another benefit to formatting your data as a table before charting it out — the ability to sort is built into the filters baked into every table heading. And if you already created the chart from the table, all is not lost. Once you sort your data in the table, your chart will update automatically. Don’t Make People Head Tilt Have you ever seen a chart that does this? Click for larger image. Tip: With bar charts, if you want the larger values to be at the top of the chart, like you see in the chart above, you need to arrange the table data for that column (in this case, the Impressions column from my Google Webmaster Tools export) in ascending order instead of descending order. It’s counter-intuitive, in my opinion, but if you don’t, you’re going to have the most insignificant data at the top of your chart. And people naturally read charts from top to bottom, so I want to put the most important data at the top. Clean Up Your Axes This chart below is a royal train wreck and has everything I hate most in chart axes. Click for larger image. Before doing anything to the axes, I’m going to remove the gridlines and the legend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |