Excel Weekly News from Contextures Nov 12, 2013
Add target range to chart + more Excel tips
In this week's Excel news, you'll see how to add a target range to a line chart, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Send Email With PDF Attachment from Excel
If you have a list of email addresses in Excel, you can use programming to send a message to each address. In this example, a PDF report is created from one of the worksheets, and sent as an attachment.
Click here to see the details, and get the sample file: Send Email With PDF Attachment from Excel
Create Fake Hyperlinks in Excel Pivot Table
Even if there are hyperlinks in the source data, a pivot table doesn't include those hyperlinks -- it just shows the address, as non-clickable text. However, with a couple of lines of programming (copied from my website), you can make a pivot table act like it has real hyperlinks.
Click here to see the details, and watch the video: Create Fake Hyperlinks in Excel Pivot Table
Create an Excel Line Chart with Target Range
With an Excel line chart, you can show the sales results from a date range, to see how things have gone. To give a better picture, you could also show the sales targets were for each month of the year. In the chart below, a blue band shows the target range, and you can quickly see which months were over or under the target amount.
Click here to see the details, and watch the video: Create an Excel Line Chart with Target Range
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- Microsoft has improved the Office Web Apps, and you can read the details on the Excel Team's blog. The feature that looks most interesting to me is the real-time collaboration in Excel files -- you can't do that in the desktop version.
- On his Excel Charts blog, Jorge Camoe post a classification of chart types. He says that a chart should either compare data or reduce data, so take a look, and see if you agree.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- If you use the MOD operator in Excel VBA, you could run into problems with large numbers. Chip Pearson suggests some alternative formulas and code that you can use.
Video: Copy Data From Browser to Excel
Instead of copying and pasting, you can quickly copy data from a web browser to Excel, by dragging and dropping. To see the steps in action, you can watch this 30 second video.
This might not work in all browsers and/or operating systems, but it's worth trying, if you frequently copy data from the web into Excel.
Chilly Blue Jay
It was just above freezing, when we went for a walk in the local park last week. Sometimes the blue jays are very noisy, but this poor bird just sat on a tree branch, shivering. Maybe he'll change his mind about staying in Canada for the winter, and head south soon.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.