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.
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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.
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.
[email protected] contextures.com
Last updated: September 4, 2020 12:39 PM