Pie Charts

Pie charts

All Data that are arranged in one row or column only can be plotted in a pie chart. These Pie charts displays the size of items in one data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), relatively to the sum of the items.

The data points (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) in a pie chart are displayed as a percentage of the whole pie. 

Charts

See Also

Column Charts & Column chart Subtypes

Line charts - Subtypes

a. Line and line with markers

Lines chart are displayed with or without markers to indicate individual data values, line charts are useful to show trends over time or ordered categories particularly if there are many data points.

The order in which they are presented is very important. If there are many categories or the values are approximately, I consider using a line chart without markers.

Line Chart

Line charts

The Arranged Data in columns or rows can also be plotted in line chart. 

This line charts shows permanent data over time, Line charts are always set against a regular scale which make them ideal for displaying trends in data at equal intervals. 

Chart Types

Available chart types

Excel 2007 provides various types of charts to lets you display data in different ways that are significant to your audience desired. When changing an existing chart, Excel allows you to choose from a wide range of chart subtypes available for you to use.

Click here for more information on how to insert a chart

Here you will learn about  Column chart subtypes.

Line charts
Pie Chart
Bar Charts

Column charts

Column charts are used to compare values across categories. Data arranged in rows or columns in a worksheet can be plotted in a column chart. This column charts are helpful for displaying data changes over a period of time or for exemplifying similarities between objects. 

Categories in column charts are usually well thought-out all along the horizontal axis and values along the vertical axis.

Changing the default Country or Region in Excel

How to Change the Default Country or Region

Changing the default country/region changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region. This setting affects various features in various Microsoft Office programs. Examples of features affected include:

• Calendar in Microsoft Office Outlook.
• Cells formatted with certain date, time, or currency options in Microsoft Office Excel.

Find links to more information on the Microsoft Office features affected by this setting in the See also section.

In Microsoft Windows Vista

1. Click the Start button, and then click Control Panel.
2. Click Clock, Language, and Region, and then click Change the date, time, or number format.

 Note    In Classic view, double-click Regional and Language Options.

3. On the Formats tab, select the country/region that you want to use in the list under Current format.

In Microsoft Windows XP

1. Exit all Microsoft Office programs.
2. Click the Start button, and then click Control Panel.
3. Click Date, Time, Language, and Regional Options, and then click Regional and Language Options.

 Note    In Classic view, double-click Regional and Language Options.

4. On the Regional Options tab, select the country/region that you want to use in the list under Standards and formats

Display numbers as currency

In the Number group, you have some other options. For example, you can change the U.S. dollar sign to another currency format, switch numbers to percents, add commas, and change the decimal location.

Hide All

1. Select the cells that contain the numbers that you want to display with a currency symbol.

How to select cells, ranges, rows, or columns

2. On the Home tab, click the Dialog Box Launcher next to Number.  This will display the format cells dialog box.

3. In the Category box, click Currency or Accounting.

4. In the Symbol box, click the currency symbol that you want.

Note: If you want to display a monetary value without a currency symbol, you can click None.

5. In the Decimal places box, enter the number of decimal places that you want to display.
6. In the Negative numbers box, select the display style for negative numbers.

 Note    The Negative numbers box is not available for the Accounting number format.

COMPUTER APPLICATION - JAVA

COMPUTER APPLICATION

some of the computer program 

1 JAVA

2 Java Script

3 Python

4 Objective-c

5 Ruby

6 perl

7 C,CH and CH

8 Sql

9 Swift

Things we use the program listed above for

JAVA

Ø JAVA is considered as the perfect language for the developer and programmer’

Ø It  is also used to develop program e.g android  operating system

Ø It is also be utilized for  mobile –based applications

Ø IT is used for establishment of android  application on tablets and smart phone

PHP

Ø It is used for enlarging a web application very quickly and effortlessly.

JevaScript

• Ø It is used in generating communication for the web
• Ø It is used in constructing  superb user interface
• Ø It is used in making of interactive web page
• Ø It is also used for animation on the web pages
• Ø It is used for loading fresh images

Python

• Ø It is used for evaluation of vast data sets
• Ø It is also used for expanding web application
• Ø It is used for data analysis
• Ø It is the user interface

Objective-c

• Ø It is used for  constructing application for (ios), language effectively
• Ø Also for producing (ios) applications that can be noticeable in application store

Ruby

• Ø It is used for beginner to learn easily

C’ CH and C

• Ø It is used for forming hardware speeding game
• Ø It is also used in ideal selection for strong desktop software
• Ø It is used as application for mobile and desktop

Sql

• Ø It is used for designing data base , such as Microsoft Sql server, Oracle, mysql.

Sweft

• Ø It is used for expanding application for apple product

Parts of Computer

1 Monitor

2 C.P.U

3 Mouse

4 Printer

5 Keyboard

6 Speakers

7 Joystics

Programs used for  QS work 

1 Microsoft word

2 Microsoft excel

3 QS card

4 WINQS

5 Computer aided design

6 Microsoft word

The programs are used for

1 Estimating Cost-planning

2 Cost Modeling

3 Contract documentation

4 Contract administrations

It also use for application of networking such as

1 L.A.N(Local Area Network)

2 W.A.N (Wide Area Network)

3 M.A.N (Metropolitan Area Network) for

          a cost management

          b contract administration

The work we do with the computer programs (QSwork)

1 For Estimating

2 Cost –planning cost modeling

3 Contract document

4 Contract administrations

Working with Chart

To create a chart 

What is a Chart?

A chart is a diagram or an effective tool you use in Excel in exchange graphically with data you have in a given table.

Solve a problem with Excel Solver

Solve a problem using Solver
Month	Q1	Q2	Q3	Q4	Total
Seasonality	0.9	1.1	0.8	1.2
Units Sold	3,592	4,390	3,192	4,789	15,962
Sales	$143,662	$175,587	$127,700	$191,549	$638,498		Color Code
Cost	89,789	109,742	79,812	119,718	399,061
Gross	53,873	65,845	47,887	71,831	239,437				Target
Salesforce	8,000	8,000	9,000	9,000	34,000				Changing
Advertising	10,000	10,000	10,000	10,000	40,000
Overhead	21,549	26,338	19,155	28,732	95,775				Constraints
Total Costs	39,549	44,338	38,155	47,732	169,775
Prod. Profit	$14,324	$21,507	$9,732	$24,099	$69,662
Profit Margin	10%	12%	8%	13%	11%
Product Price	$40.00
Product Cost	$25.00

Solve a problem using Solver

values to maximize or minimize another price, enter and change constraints, and save a difficulty model.