How to Make a Graph | Charts in Microsoft or MS Excel

Making Graph | Charts in Microsoft Excel is Essential part of any private or public organization employee. Nowadays employee needs many different functions and graphical representation for his or her sheet. Microsoft Excel 2010 is a crucial handy tool for them which have capabilities to create different functions and Graph | Charts instantly.

Here are some basic steps you need to follow:

Step 1: Open MS Excel 2010 > “Browse through your start menu than go for Microsoft office, select Microsoft Excel.”

Step 2: Let me Walk you through one example so you can get clear idea about is: Put  this data in cell A1 “color”, now type 7 color name from cell A2 to A8 (Red, Orange, Yellow, Green, Blue, Indigo, Violet ). Type intensity in B1 cell, add intensity ratio from cell B2 TO B8 (Very High, High, Medium, Low, Medium, High and Very High)  

Step 3: Put your cursor or mouse pointer on a cell contained data table. If you will not put on cell than the chart option will not enable to you.

Step 4: Now Select > Insert menu click on the down arrow under the column option in the Charts Section.

Step 5: Select the chart option under >‘3-D Column’. You will see new graph appear in your sheet. Showing color intensity of seven different color. 

Step 6: Selecting the corner of graph you can actually change the size of it, Also you can drag it around your work-sheet.

Useful Guideline:

You can change type and series of chart by selecting and right clicking on it. Find out which will appropriate to you, you can walk through different chart option like column chart, Pie chart, Corn chart etc. You can choose chart layout from > design tab and clicking on >change chart type ...its done....enjoy

How to convert a WPS File Extension in other File extension

Now what is WPS?

File name.wps extension stands for Word Processing Software similar like Microsoft word document (.DOC). WPS now available totally free with all Microsoft major products. You can still use those Microsoft works files (.WPS) with little bit of effort, you need to convert it first.

Step1: First you have to open Microsoft word

            “If you don’t know how to open Microsoft word, follow these simple steps.

i) Click on Windows logo in bottom-left corner”

ii) Type ‘Microsoft Word’ in search box at bottom of start menu. 

    You will find if you have installed it

iii) Click on Microsoft word or hit enter.”

Step 2: Click on >‘File Menu’ then Click on >‘OPEN’

Step 3: Now choose the .wps file location and open it in Microsoft Word

Step 4: Click on >’File Menu’ again and click on >‘Save As’

Step 5: Now you have different option of saving the file. Microsoft Word should save it in different format what you have selected in menu like Example.doc or Example.

How to Delete Your Browser's History

 
Step 1: Go to the >start menu

Step 2: Open >Control Panel(if you use windows 7 and if you use xp than go to setting than click on control panel)

Step 3: Click on >internet option.

Step 4: You are on general tab(make sure about it).

Step 5: Click on >Delete button.

Step 6: Select whatever you want to delete than click on delete if ask than click on yes...done...enjoy

How to Change a Printer from Offline to Online

Once you added USB or networked or wireless printer with your PC. You will able to send documents for print, it’s possible you got error some time to prevent this situation you should use this guidelines. So you can easily change status of printer from offline to online.

Guidelines

USB or networked or wireless printer

Step 1: Click on >Start menu and click on the >Printers and Faxes icon. This will show you currently added printers with your system.

Step 2: Double-click on the >printer icon which you want to change to online. A pop-up window displaying all current print tasks will open.

Step 3: Go to Printer in the menu bar of the pop-up window and uncheck >Use Printer Offline. By doing this procedure you will able to change the status of printer from offline to online.

How to Rotate the Screen in Windows XP

If you have done mistake by randomly pressing the sequence of key and you find your screen get rotated, don’t be afraid. It easy to rotate your screen by pressing combination of some hot keys. Here is the guidance for problem like this.

Guidelines

IN Windows XP

Step 1: Hold Ctrl + Alt + arrow key will be (left, right, up or down) to rotate your display screen.

Step 2: Hold the Keys and arrow keys until you have the rotation of the screen done. This will work with most available video drivers on Windows XP. If it’s not done, check out Step 3.

Step 3: Click on >Start then go to >Control Panel select >Display then switch to >Setting tab, and select the >Advanced button. Count on an >Orientation option. Select your desired orientation.

How to Make a Graph Using Excel

Using Microsoft Excel we can create a graph easily. All you need to do give all data to graph and it creates for you graph. Excel also provide multiple option to select which option we need.

Microsoft Excel 2007

Step 1: Give Label name to data you want to graph. In Row 1, type the label name for each cell of data you  plan to graph. For example, type "week" in cell A1 and "day" in cell B1.
 

Step 2: Enter the data that you need to plot a graph. Under the label name you have to put at the top of each column, type the information you need to in graph. For an example, type the week of the month under the name in Column A ("MON" in A2) and the cells under the heading in Column B, to correspond with the week in Column A.

Step 3: Select the data for the graph which you needed. In Excel spreadsheet you need click on data and drag in it.

Step 4: Click on the "Insert" tab, Top of the sheet.

Step 5: Locate the "Charts" section of the insert level. Many types of graphs (called "charts" in Excel) are available there.

Step 6: Click on the type of graph you need to create. When you select that the options for that type of graph will display on sheet.

Step 7: Click on the option for the graph you need to create on Excel. Then Excel provides the graph on the Excel Spreadsheet according to your data which are included by you.

Step 8: If you need to change the title or any text you can easily edit it just click on It and write whatever you need to.

How to Format a Hard Drive with Windows XP

If you want to format a hard drive with installing Windows XP

It is very useful for clearing everything off a secondary drive (Windows XP Was not installed) or installing a fresh copy of Windows.

Formatting a computer hard disk is simple and helps to remove viruses, storage problems and other hard problems.

Guide lines

Step 1: When you format a computer hard disk you will lose all data on that disk drive. So, backup it first. And you have also need windows XP disk and driver disk too.

Step 2: You need to backup also the My Document data and your bookmark plus your favorite sites list form your browser

Step 3: Save your data before formatting

Guide lines for installing the XP and formatting the drive

Step 1: Here we can install afresh copy of Windows XP and Formatting the Hard Drive So backup your data first

Step 2: Insert your Windows XP Bootable disc into your CD drive [Any edition doesn’t matter].

Step 3: Your cd boots and you see this message "Press any key to boot from CD...” so press any key.

Step 4: It took some time to load up all files and you see many message choose "Press ENTER to set up Windows XP." Press Enter or you can return.

Step 5: Here you select where you want install XP. Also you can delete the partition. You also see partition list. Use the Up and Down arrow keys to select your "C:" partition and press the 'D' key (also you see this "Unpartitioned space" and you have no C: or D: partitions, skip this step).press enter next screen press the 'L' key to deleting the partition permanently.

Step 6: Now you are back on the screen to choose where to install Windows. if you see this "Unpartitioned space xxxxMB." Select this with the arrow keys and press the 'C' key to create a partition. Choose whatever you like.

Step 7: In Next screen you see this "C: Partition1 [New (Raw)]xxxxxxMB." select this entry and press enter.

Step 8: Choose NTFS File system and with quick format and press enter.

Step 9: Here windows will install in system so wait for it.

Guide lines for formatting the secondary disk drive

Step 1: First Right-Click on the "My Computer" and select "Manage."

Step 2: The window titled "Computer Management" will up. Select "Storage" from lest side, then select "Disk Management (local)" from right side by double-clicking it.

Step 3: Here you see the partition editor. Partitions are separations of space on a drive. You need one partition per drive.

Step 4: Select the partition right-clicking on the partition's box and selecting "Delete Partition", Click on yes.

Step 5: Now you see "Unallocated" under its size. Right click on it and select "New Partition...", The New Partition windows up.

Step 6: In the New Partition Window click next. Select "Primary Partition" and click next. Choose size and click next again. Choose drive letter or computer choose for you, and then click next.

Step 7: Choose NTFS file system for formatting. Leave the "Allocation unit size" as "Default." Enter volume label and click finish

Step 8: Wait for some time when you see the drive was healthy you can use it its done....enjoy...

How to format a pen drive Using Command Prompt

If you stuck with your pen drive format problem use this method

This method also work with infected pen drive

It use deep format process so pen drive get clean

Step 1: Open command prompt

Step 2: Type format (drive letter f :  ) press enter (example c:\ >format f: )

Step 3: Wait for process to complete (when 100 percent completed)

Step 4 : Assign a drive name and press enter

Its done
Enjoy...

How to capture your screen and record it

Use Camstudio software for capture your screen .
And Using it We can easily capture or Record the screen as video
Also We can Convert AVI format into flash format

IT is free to download and much easier to use