Windows Guides Feed

Excel 2007/2010: Creating Charts [How To]

Posted by Thomas On January - 20 - 2012

One of the improvements in Excel 2007 is the rebuilt Chart Tool.  “It used to be so easy” to create charts in Excel, just highlight an area of cells and click Create Chart, and voilá. Well it still is – it only looks a bit different.  In this mini-tutorial I’m using an example from work, tho the names, and numbers have been altered.

The Mission

At work we have tightened security on mobile Exchange Synchronization. A security policy has been set which requires that we ask each of the 2.500 users to read the new guidelines. Failure to accept the new policy guidelines will result in the user loosing access to the server. To be able to monitor the progress of this work (making sure we know that every user has read and accepted) I was asked to create a chart to graphically display the weekly progress,  number of emails sent, number of accepts etc.  The challenge is that we only record names, and dates for each occurrence (notice sent, reply received, account open or closed).

Read the rest of this entry »

Excel 2010: Sparklines

Posted by Thomas On October - 25 - 2011

Excel 2010, did not come with too may new features. It’s hard to come up with  ideas on how to improve something that is already a great product, I’m sure. But there was one new thing I’ve found quite useful: Sparklines.

Sparklines – What’s that ?

Read the rest of this entry »

Every time you create a new workbook in Excel, you get a document containing three blank sheets. Do you ever use more than one ? Or, do you always use more than three ? In this Quick-Tip I’ll show you how to set Excel to create new workbooks containing the number of sheets you require, whether it’s one or ten.

Here’s How

Read the rest of this entry »


Computer tips in your inbox
Sign up for the Windows Guides newsletter to get PC tips and access to free Windows books (More details)

Enter your email address:
 

Popular Guides

See which sites have been visited on your PC (even if private browsing mode is used)

Create a Windows 7 System Repair Disc

Best Free Anti-malware

Hibernate vs. Sleep vs. Shut-Down

i3, i5, and i7; Dual, Quad, Hexa Core Processors. How to they Differ?

Intel's Ivy Bridge Processor: new Features

Submit Your Tip
Submit your computer tip to us; receive full credit for all published tips

Windows Guides on Facebook