Business Brief

		Secure your Business PCs without slowing them down 10.23.2012 1:55 PM GFI's small-footprint antivirus keeps businesses secure without slowing them down. Vipre is currently offering a free 30-day trial.
		CloudOn expands app to build on 'Office as a platform' 10.17.2012 3:03 PM While the world waits for dedicated Microsoft Office for tablets, CloudOn is providing Word, Excel, and PowerPoint via fresh iPad and Android apps.

		5 Silicon Valley tech companies we all want to work for 10.20.2012 1:16 PM Silicon Valley firms dominate a list of the companies with the best perks. Here are five top tech firms with great benefits.
		Seven apps making the most of HTML5 10.22.2012 11:45 AM HTML5 is more than a few years old and no longer a curiousity. Web pages that used to simply emulate a piece of paper are now expected to do something snazzy to justify their existence. Thanks to HTML5, along with innovations in JavaScript and CSS, interactive logic is a standard strategy for Web programming, and full-fledged Web apps are everywhere. All it takes is a few extra tags to rewrite the world's software as a Web page.
		7 ways Windows Server 2012 pays for itself 10.17.2012 12:30 PM These new and improved 'supersaver' features offer the biggest return on your Windows Server 2012 investment
		App scanner tells you if a mobile app is safe—before you install it 10.17.2012 2:05 PM The Zscaler Application Profiler vets Android and iOS apps so you can assess their security risk.
		Microsoft Office web apps get big update ahead of Windows 8 10.22.2012 2:00 PM Microsoft just completed its makeover of Office Web Apps, adding improved touch support for phones and tablets and a modern sheen to complement the upcoming Windows 8.
		Windows 8: Businesses may take years to adopt new OS 10.23.2012 6:34 AM Windows 8 is so different from Windows 7 that the learning curve for end users will be a nightmare
		Wall Street Roundup: Mixed earnings prove tough quarter 10.21.2012 9:55 AM Some of the biggest names in tech reported quarterly earnings last week, and the resulting picture is not pretty. The main culprit for the weak earnings reported this week is a slump in the PC market, but uncertainty about the global economy is weighing down almost all sectors of tech.
		Google quarterly financial statement out early, shares pummeled 10.18.2012 11:16 AM Google's third-quarter financial results are out early and its shares are taking a beating because the company missed revenue and net income expectations.
		App Spotlight: Maluuba for Android is like Siri—without the backtalk 10.19.2012 1:27 PM Schedule meetings, create reminders, find businesses and more with this voice-activated helper app, which listens but doesn't talk.
		Windows' share of Microsoft sales falls to four-year low 10.19.2012 3:20 PM The Windows division's share of Microsoft's revenue last quarter dropped to a four-year low as Windows 7 sales stalled before the launch of Windows 8.

Microsoft Business Insites Tech Support Offers Products

Offers Big Easy & Cloud Easy Offers Earn rebates that can be used for more software or services when you make qualifying Microsoft volume license or Online Services subscription purchases between October 1 and December 31, 2012. More details on Big Easy Offer 9 and list of eligible Microsoft products More details on Cloud Easy Offer and list of eligible Microsoft Online Services Tips & Tricks Manage Website Passwords. Windows 7 Control Panel includes an application called Credential Manager that allows you to save your usernames and passwords for websites and other resources. Credentials are saved securely in the Windows Vault, which can be backed up and restored. Office 365 in Action: Daily Live Demo & Chat See how Microsoft Office 365 can help improve the effectiveness of your business. Please join us for a live 30-minute demo & chat with a Microsoft specialist. Explore Learn From Organizations Like You: Getting Started with Office 365 Watch the case study to find out how Meals on Wheels of Greenville County worked with partner PTG to adopt Microsoft Office 365. "Any investment we're making, we'll get back ten-fold." – Liz Seman, Executive Director, Meals on Wheels. Have Your Own Success Story? We'd love to hear about your organization's success with Microsoft products and services. Please reach out to us and share your story. Meet Your Local Microsoft Retail Store's Business Specialist The Business Specialist at your local Microsoft retail store is always here to help you make the best technology decisions for your business. Find a store near you and come in to learn about the ways we can help you meet your small business goals—with everything from hardware upgrades to training to exceptional service and support. SHARE THIS NEWSLETTER

Update Charts Automatically When You Enter New Data

Category: Charts & Graphics | [Item URL]

Q. I use an Excel workbook to track and chart daily sales. Since the number of data points changes every day, I have to update the chart manually so it includes the new data. How do I get the chart range to expand automatically?
When you select a chart series in Excel 97 or later, the ranges used by the series are outlined on the worksheet. You could simply drag a corner of the outline to extend the range.
This document describes another approach that uses formulas to define the ranges used in a chart. The steps listed below describe how to create dynamic ranges for the chart shown in figure below.

1. Enter the data and create the chart shown in the figure.
2. Select Insert, Name, Define to bring up the Define Name dialog box.
3. In the 'Names in workbook' field, enter Date. In the 'Refers to' field, enter this formula:
   =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1! $A:$A)-1)
4. Click Add to create the name. Notice that the OFFSET function refers to the first data point (cell A2) and uses the COUNTA function to get the number of data points in the column. Because column A has a heading in row 1, the formula subtracts 1 from the number.
5. Now type Sales in 'Names in workbook', and in 'Refers to' enter this formula:
   =OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)-1)
6. Click Add, and then OK to close the dialog box.
7. Activate the chart and select the data series. In this example, the (unmodified) formula in the formula bar will read:
   =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10, Sheet1!$B$2:$B$10,1)
8. Replace the range references in the SERIES formula with the names you defined in steps 4 and 5. The SERIES formula should read:
   =SERIES(,Sheet1!Date,Sheet1!Sales,1)

After performing these steps, you'll find that the chart updates automatically when you add new data to the worksheet.
To use this technique for your own data, make sure that the first argument for the OFFSET function refers to the first data point, and that the argument for COUNTA refers to the entire column of data. Also, if the columns used for the data contain any other entries, COUNTA will return an incorrect value.