CHRISdotTODD

When you create Excel charts, you can populate the title with a formula. You might find this helpful to display a total quantity, such as in this example. Suppose you have 30 students and you are displaying their grade distribution in a pie chart. Here's what you do. Steps 1 - 4 set up the data; step 5 creates the Title formula; step 6 creates a pie chart. In the first column, skip the first line (A1) for the Title (we'll come back) In rows 2 - 6 of the first column (A2:A6), add the letter grades, A - D and F In column 2, rows 2 - 6 (B2:B6), add the number of grades of each type In column 2, row 7 (B7), sum the number of grades to get your student total Now go back to the first cell (A1) and add the following formula: ="Grade Distribution, " & B7 & " students" B7 is the same cell we put our total in, in step 4 If you want to format the value contained in B7m remember the TEXT functioned discussed in an earlier post Create your pie chart Highlight t

05-Dec-08 update: Webware posted an article describing the Koobface virus coming from Facebook. I just received an email from our corporate IT department, as they are temporarily blocking Facebook and MySpace due to a worm infected file. The method of infection is: There is a prompt to update your flash player when visiting one of these sites . This executes a worm that infects explorer.exe and other critical operating system files. To date there is no easy method to clean an infected system. The IT staff is working to clean the 20 odd systems that have been affected to date. I'm not sure how real it is, but it serves as a good reminder to make sure updates are coming from known URLs.

If you're a Sprint or Cogent customer, relying on them for your Internet connectivity, you're probably already aware of this article from Scott Woolley of Forbes. In late October, due to differences between these companies, Sprint severed the Internet backbone connection between them. The result was customers on both sides not being able to reach all parts of the Internet. The feud goes back several years, with what appears that Sprint is being a bit of a bully. It is common practice for the Internet backbone carries to exchange traffic between them for no cost. The rationale is that it benefits both companies' customers and the traffic is even enough both ways where there is no profit to be made by one company or the other. In this case, "...Sprint stood to gain $1.5 million or so in annual revenue, which would add .004% to the company's $40 billion in annual revenue." (Note that this was based on Sprint's billing justifications; there's nothing to s

It's not uncommon during birthdays and Christmas to get new electronic gadgets and have the need therefore to throwout the old gear. Before you throw them out, consider the toxic metals that you may be adding to our landfills. Instead go to Earth911.com and find a recycler near you. In addition to electronics, you can search for locations that will take paper, metal, hazardous materials, plastic, and more. So the next time you need to dispose of electronics or other materials, start with Earth911.

Recently my Apple TV remote quit working. When I pressed the buttons, the light on the Apple TV lit, but nothing happened. I've since learned, similar to "pairing" your wireless key for your car, the Apple TV remote needs to be "paired" with your Apple TV. It's an easy process: Hold the Menu and Previous buttons for 6 seconds. You should see a new graphic appear, a remote and a broken chain. Then, Hold the Menu and Next buttons for 6 seconds. The graphic will go away, as you have just "paired" your remote with your Apple TV.

I got a new external hard drive to use for backups. Before starting, I wanted to format the drive as NTFS, instead of the default FAT32. When I tried though, the system always gave me an error message,"volume is in use by another process." Of course I checked and checked, and was certain nothing else was using the drive. It turns out that the drive when initial setup was added to the System Restore Monitoring; I needed to remove it to format the drive. Here's how to do that: Go to Start >> All Programs >> Accessories >> System Tools >> System Restore Click the System Restore Settings in the right pane Highlight the drive Click Settings Check "Turn off System Restore" on this drive Click OK Click OK again Click Cancel (to close the Welcome to System Restore dialog) For a drive that I am using as a backup drive (a data only drive), there is no reason to use System restore, so after formatting, I did not re-enable. Note that if you are a Win

I recently discovered a very helpful search tip for Amazon. When I shop, I like to sort by price, low to high. What usually happens though is I then have to go through all the match but irrelevant items before I get to what I really want. What I learned is that if I use a minus (-) for the items I don't want to see, then I no longer have this issue. Here's an example: Searched for "upconverting DVD players" Sort by price: low to high First thing I get is a bunch of cables Change search to " upconverting DVD players -cables " Sort by price: low to high Now the first results are the low-end upconverting DVD players You can also add multiple items to exclude. For example: " upconverting DVD players -cables -progressive ". BONUS Tip: Use this URL to find all Electronic items that are 85% or greater off of list price: http://www.amazon.com/gp/search/?node=172282&pct-off=85- . Change 85 to any number to get the percentage you are looking for. Thanks

Many stores have plans to close some or all locations after the Christmas holiday. Before you buy that gift card for little Johnny, better check out whether they'll still be around.

When I get data from the screen view in Salesforce.com, the results have an empty row between each row of data. With a little VBA help to create a macro, it's easy to clean it up. Here's how to do this: Go to Tools >> Macros >> Visual Basic Editor OR press Alt-F11. The Project Explorer should be open in the upper-left corner. If not press Ctrl-R. In the Project Explorer, double-click the worksheet name to add the macro only to a single worksheet. Double-click ThisWorkbook to have it available to all worksheets. Paste the code (option 1 or option 2) into the worksheet. Go to View >> Microsoft Excel OR press Alt-F11. Select column A. Go to Tools >> Macros >> Macros OR press Alt-F8. Highlight the DeleteRows macro and click Run. Wait as it process through each row. To make it faster, only highlight the rows you want checked. OPTION 1 Sub DeleteRows() RowCount = Selection.Rows.Count ActiveCell.Offset(0, 0).Select Application.ScreenUpdating = F

Forbes reports on recent work that has identified many airport hotspots not being secure. This is a good reminder to all of us who use hotspots that we need extra security. First, if you can get on the hotspot, so can anyone else. With a little work and help from programs such as Cane and Abel, anyone can intercept everything you send and receive. Other people may just set up their laptop to look like a hotspot, so when you connect, you are actually connecting to their laptop. Again programs are readily available to make this work with relative ease. Your job, if you're going to use hotspots, is to only communicate with VPN on. VPN will encrypt data as it is sent and received between your laptop and the VPN server. If your company does not provide you with VPN or you need it for private use, try services such as PublicVPN or HotSpotVPN . For a small fee, these services will protect you . The same rule also applies to any public network that you physically connect to such as from