Column Line Chart + more Excel tips

Excel Weekly News from Contextures 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. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

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. 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:

Excel Announcements

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

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.

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.


See more recommended Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright ©2019
All rights reserved.