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 - firstname.lastname@example.org
- Compact Buttons & Captions
- Column Line Chart in Excel 2013
- More Excel Tips
- Excel Announcements
- Video: Drop Down Opens at End of List
- Weekly Photo: Southern Dreams
- Featured Excel Product
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:
- Learn a very useful keyboard navigation shortcut from Gašper Kamenšek – I didn't know that shortcut, and it will come in handy!
- When you import data with Power Query, the dates might not look right on the worksheet. Ken Puls shows how to set the date formats.
- Michael Ashton built a User Defined Function because Excel's PRICE and MDURATION functions return errors for negative bond yields.
- To clean up data, Steve Chase uses the TRIM function, which gets rid of extra spaces.
- Tanner Bell is still working on his Fantasy Baseball workbook, and this week he is calculating custom rankings.
- Jerome Cukier, data visualization designer at Facebook, looks at some of the new problems with dashboards.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
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.
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.
Contextures Inc., Copyright ©2017
All rights reserved.