Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

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 ddalgleish@contextures.com

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.