Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 -  ddalgleish@contextures.com

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:

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

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.

_____________

________________________

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

 

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2015
All rights reserved.