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.
Save time with our "Done For You" 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 ©2018
All rights reserved.