Contextures News 20150210

Column Line Chart + more Excel tips

February 10, 2015

In this week's Excel news, you'll see how to make a column line chart in Excel 2013, and much more, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Compact Buttons & Captions

You can add buttons on an Excel worksheet, to run macros, or use as hyperlinks. Instead of adding big buttons with large bold text on a worksheet, use compact buttons, with captions at the right-hand side. With this technique from Alex J, the worksheet looks cleaner, and the captions are easier to read.

Click here to see the details, and watch the video: Compact Buttons & Captions

Create Column Line Chart in Excel 2013

After you create a pivot table, you can insert a pivot chart, based on that table. Then, change the chart type for one of the series, and plot it on a secondary axis, to make a combination column-line chart.

See the details in my blog post, and watch the short video: Create Column Line Chart for Excel 2013 Pivot Table

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

  • Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.

Video: Drop Down Opens at End of List

When you click the arrow to open a drop down list, the selection might go to a blank at the bottom of the list, instead of the first item in the list. This can happen if you leave blank cells, where you can add new items later. To avoid that problem, use a dynamic list, that adjusts automatically.

Click here to watch the short video that show how it works: Drop Down Opens at End of List.

Southern Dreams

I've been stuck inside all week, and to cheer myself up, I looked at some of the pictures from last February, when we were in Hilton Head, South Carolina. It's not hot there in the winter, but it's warmer than Canada, and there's no snow.

We saw this bird (I think it's an egret), and many others, while walking through one of the lovely parks on the island.

weekly photo

Featured Excel Product

If you're ready to learn about Excel's pivot tables, or improve your skills, then the Xtreme Pivot Tables course, from John Michaloudis at My Excel Online Training, is the ideal solution. This course has over 200 videos, with approximately 9 hours total viewing time. The lessons are comprehensive and easy to understand, and you can download the sample Excel files, to follow along.

There are several sample videos that you can watch, to decide if the course if right for you. The course outline shows you the details of the extensive topics that are covered.

You'll go from beginner level, all the way up to advanced, and will be ready to tackle new Excel projects at work, with confidence! Take a look at the course details, and get started right away.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.


Last updated: September 4, 2020 12:39 PM