Question about Microsoft Excel for PC

1 Answer

Sort data and create graphs for each quarter

I do have a spreadsheet where I am entering data for job my company have done.
I do have 19 different equipments, so I have to read each equipment find how many operating days it was done for each equipment, sortted out and then find out from other two different columns how many hours was downtime, and calculate how mouch money we have to pay back to compoany we did serivice.
Then I have to create a spreadhseet for each quarteer and graph with performance, actually with downtime.

Anybody interested to help and I will send a spredsheet.

Thank you very much in advance.



Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers
Re: sort data and create graphs for each quarter

You could have all the data in the same worksheet, but sort it using filters, eg click on the little arrow at the top of each column, then click on the item listed. this will then show only those rows associated with that item.

Posted on Jan 28, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What is excel


Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.


Jun 04, 2011 | Microsoft Excel for PC

1 Answer

What is excel

What is Excel blankxl_250.jpg
Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Business & Productivity Software

1 Answer

Excel 2007 question

Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".

May 14, 2009 | Microsoft Office Excel 2007

1 Answer

Data From Table Auto Fill

You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.

Apr 08, 2009 | Microsoft Office Access 2003 (077-02871)...

1 Answer


Excel is a spreadsheet - it is less structured than a database and all of the data appears on one (or more) pages along with many calculations and summaries of data.
A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.
Some tasks can be performed equally well in either spreadsheet or database -
Often data is stored in a database but analysis is done in the spreadsheet.

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

Excell workbooks

You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.

Jul 14, 2008 | Microsoft Business & Productivity Software

1 Answer


I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Business & Productivity Software

2 Answers

Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

1 Answer

Microsoft excel(data analysing)

Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

77 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides