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 email@example.com
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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.
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.
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.
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.