What are the various types of charts? Explain each. -Technology

What are the various types of charts? Explain each. -Technology
by

1 Answer

Answer :

The various types of charts in Excel are given below:Line Chart:Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data over time, set against a common scale and are therefore ideal for showing trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis and all value data is distributed evenly along the vertical axis.Pie Chart: Data that is arranged in one column or row only on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are displayed as a percentage of the whole pie.Scatter Chart: Data that is arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart. Scatter charts show the relationships among the numeric values in several data series or plots two groups of numbers as one series of XY coordinates.Bar Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items.Area Chart: Data that is arranged in columns or rows on a worksheet can be plotted in an area chart. Area charts emphasize the magnitude of change over time and can be used to draw attention to the total value across a trend, e.g. data that represents profit over time can be plotted in an area chart to emphasize the total profit.
by

Related questions

Pick up the incorrect statement from the following: (A) The various functions under each activity, are shown by one bar on Bar Charts (B) Bar chart establishes the interdependency of one event on another (C) Only approximate percentage of the completed work is reported (D) None of these

Description : Pick up the incorrect statement from the following: (A) The various functions under each activity, are shown by one bar on Bar Charts (B) Bar chart establishes the interdependency of one event on another (C) Only approximate percentage of the completed work is reported (D) None of these

Last Answer : (B) Bar chart establishes the interdependency of one event on another

Write down the importance of legend in charts. -Technology

Description : Write down the importance of legend in charts. -Technology

Last Answer : With the help of legend, each data series can be uniquely identified by assigning a unique color or pattern.

For what purpose pie charts are useful? -Technology

Description : For what purpose pie charts are useful? -Technology

Last Answer : Pie charts are useful for the following purposes:1. They convey approximate propositional relationship at a point in time.2. They compare part of a whole at a given point in time.3. Exploded portion of a pie chart emphasizes a small proportion of parts.

How are charts created in Excel? Write the steps. -Technology

Description : How are charts created in Excel? Write the steps. -Technology

Last Answer : Creating a Chart:Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:1. Select the data that you want to show, including the ... Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

Which of the following charts is used for comparing the changes in data over a period of time? -Technology

Description : Which of the following charts is used for comparing the changes in data over a period of time? -Technology

Last Answer : (d) Line chart emphasizes on a rate of change rather than volume of change over time.

Various activities of a project, are shown on bar charts by (A) Vertical lines (B) Horizontal lines (C) Dots (D) Crosses

Description : Various activities of a project, are shown on bar charts by (A) Vertical lines (B) Horizontal lines (C) Dots (D) Crosses

Last Answer : (B) Horizontal lines

Explain the concept of cell referencing along with its various types. -Technology

Description : Explain the concept of cell referencing along with its various types. -Technology

Last Answer : Excel supports three types of cell referencing, which are as follows:1. Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a ... from one cell to another, the absolute reference stays the same but the relative reference changes.

Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Description : Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Last Answer : 1. Drawing2. Word processing3. Desktop publishing4. Spreadsheet5. Database

Write HTML code to display various bullet types. -Technology

Description : Write HTML code to display various bullet types. -Technology

Last Answer : LotusRoseSunHoonoutput

What is Multimedia? What are the various types of hardware used in creating a multimedia project? -Technology

Description : What is Multimedia? What are the various types of hardware used in creating a multimedia project? -Technology

Last Answer : Multimedia is a means to process and structure information into a well-defined structure. Multimedia is called so because it incorporates many other media such as text, graphics, animation, audio ... following hardware devices - CPU, Monitor, Scanner, Touchscreen, Video grabbing card, mouse etc.

What charts (1) the cost to your organization of the unavailability of information and technology and (2) the cost to your organization of recovering from a disaster over time? a. Disaster recovery plan b. Hot site c. Cold site d. Disaster recovery cost curve

Description : What charts (1) the cost to your organization of the unavailability of information and technology and (2) the cost to your organization of recovering from a disaster over time? a. Disaster recovery plan b. Hot site c. Cold site d. Disaster recovery cost curve

Last Answer : d. Disaster recovery cost curve

Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Description : Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Last Answer : C. Resource Breakdown Structure

Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Description : Which of the following types of Organizational Charts can be BEST used to track project  costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Last Answer : C. Resource Breakdown Structure

What are different types of control charts?

Description : What are different types of control charts?

Last Answer : 1. X bar S chart 2. X bar R chart 3. I MR Chart 4. C Chart 5. U Chart 6. np Chart 7. P chart

Explain various attributes of <img> tag. -Technology

Description : Explain various attributes of tag. -Technology

Last Answer : Attributes of TagAn attribute is an extra piece of information associated with a tag that provides further details about the tag.Following are the various attributes of tag:The src Attribute: The src (source) ... the width of the border around an image. By default, an image has no border in HTML.

Explain the various views of a slide available in PowerPoint 2007. -Technology

Description : Explain the various views of a slide available in PowerPoint 2007. -Technology

Last Answer : In Microsoft Office PowerPoint 2007, different views of a slide are used to edit, print and deliver a presentation. PowerPoint slide views can be found in two places as follows:1. On the ... can make universal style changes to every slide, notes page, or handout associated with the presentation.

Explain the various values associated with “scrolling” attribute of FRAME tag. -Technology

Description : Explain the various values associated with “scrolling” attribute of FRAME tag. -Technology

Last Answer : The scrolling attribute of FRAME tag can take 3 values:Yes will insert both the scrolls irrespective of the size of the sub-window.Auto will insert the scrolls only when the contents of the sub-window are not visible.No will not insert any scrolls even when all the contents are not visible.

Under the topic of things we've recently become aware, I just found out that a country song that hit the top of the charts was removed. It was a hit, but by a gay person of colour. Can you help explain this?

Description : Under the topic of things we've recently become aware, I just found out that a country song that hit the top of the charts was removed. It was a hit, but by a gay person of colour. Can you help explain this?

Last Answer : Can you cite a reference to its removal? I'm going to search now. . CBS News indeed reports it was removed. I'm on a mobile device and can't link. The Country Music authority that ... did not have enough elements to qualify as a country song. The decision is tainted with racism and homophobia.

What part of a graph can be used to explain what data or pie charts section represent?

Description : What part of a graph can be used to explain what data or pie charts section represent?

Last Answer : legend>

Online discussion through posts about various topics is called (a) E_Discussion (b) Newsgroup (c) E_mail -Technology

Description : Online discussion through posts about various topics is called (a) E_Discussion (b) Newsgroup (c) E_mail -Technology

Last Answer : (b) Newsgroup helps for online discussion.

Sharvan Joshi is a student of Political Science and is a keen researcher of political issues related to various countries and states. -Technology

Description : Sharvan Joshi is a student of Political Science and is a keen researcher of political issues related to various countries and states. -Technology

Last Answer : 1. Sharvan should develop a blog.2. Twitter and Facebook.

Describe the various components of multimedia. -Technology

Description : Describe the various components of multimedia. -Technology

Last Answer : Various components of multimedia are described as follows:1. Text It is the most widely used and flexible means of representing information on screen and conveying ideas. It is not always a good idea to ... In multimedia, now-a-days animation is being used as 2-D animation and 3-D animation.

Write various areas, where multimedia has found its applications in present world? -Technology

Description : Write various areas, where multimedia has found its applications in present world? -Technology

Last Answer : Multimedia can be used in a variety of ways. Various application areas of multimedia are as follows:1. Creative IndustriesCreative industry refers to a range of economic activities which are concerned with the ... can provide information and help to the consumers when no one is there to help them.

Letters, numbers and symbols are the various forms of ………….. -Technology

Description : Letters, numbers and symbols are the various forms of ………….. -Technology

Last Answer : Letters, numbers and symbols are the various forms of data.

Define various alignments of align attribute with example. -Technology

Description : Define various alignments of align attribute with example. -Technology

Last Answer : There are some values of image alignment attribute as follows:Middle AlignmentThis alignment is different in both Internet Explorer and Mozilla Firefox. In Internet Explorer, this alignment aligns the image ... effect reproduction, usually by providing a mechanism for the union of sperm with eggs.

Describe the various parts of the folder window. -Technology

Description : Describe the various parts of the folder window. -Technology

Last Answer : It is a location where you can store your files. You can create any number of folders and even you can store a folder into other folders (sub-folders). Windows use various folders to store and manage ... list are organised.7. File List This is the list of contents of the current folder or library.

…………. represent graphical representation of various files and programs of an operating system. -Technology

Description : …………. represent graphical representation of various files and programs of an operating system. -Technology

Last Answer : Icons represent graphical representation of various files and programs of an operating system.

…………. represent graphical representation of various files and programs of an operating system. -Technology

Description : …………. represent graphical representation of various files and programs of an operating system. -Technology

Last Answer : Recycle Binrepresent graphical representation of various files and programs of an operating system.

The ………….. contains various options such as File, Edit, View etc. -Technology

Description : The ………….. contains various options such as File, Edit, View etc. -Technology

Last Answer : The menu barcontains various options such as File, Edit, View etc.

……………. are the collection of various information. -Technology

Description : ……………. are the collection of various information. -Technology

Last Answer : Files are the collection of various information.

Pictures can be added to Word documents and they cannot be formatted in various ways. -Technology

Description : Pictures can be added to Word documents and they cannot be formatted in various ways. -Technology

Last Answer : FalsePictures can be formatted in various war’s after adding it to the Word document like changing the shape, adding a border, modifying effects, applying a predefined style and more.

What are the various measures that should be taken to prevent spyware from overtaking your system? -Technology

Description : What are the various measures that should be taken to prevent spyware from overtaking your system? -Technology

Last Answer : Preventions of SpywareDue to the seriousness of spyware and the harm, it can affect your system and personal information, it is highly recommended you to take the given measures to prevent ... and are capable of blocking suspicious traffic, which can prevent spyware from infecting your system.

It is an electronic messaging system used by various commercial organisations to send bulk -Technology

Description : It is an electronic messaging system used by various commercial organisations to send bulk -Technology

Last Answer : 2. Spaman electronic messaging system used by various commercialorganizations to send bulk messages to a large number of E-mail addresses.

Write down the name and purpose of various components of a chart. -Technology

Description : Write down the name and purpose of various components of a chart. -Technology

Last Answer : Various components or parts of the chart are as follows:1. X-axis Refers to a horizontal axis, which is also known as category axis.2. Y-axis Refers to a vertical axis also known as ... Data label Provides additional information about a value in the chart, that is coming from a worksheet cell.

List the various forms of software piracy. -Technology

Description : List the various forms of software piracy. -Technology

Last Answer : Software piracy means copying of data or computer software without the owner's permission. However, most peoples are aware about piracy and know that it is illegal, yet the piracy is uncontrollable. This ... is the registered word or text/logo depicting the identity of a product, work or company.

What are the various possible careers in IT? -Technology

Description : What are the various possible careers in IT? -Technology

Last Answer : The following are important jobs in IT:1. Computer Programmer A computer programmer is a person, who codes various computer programs for users, so that they can perform desired tasks on ... and software documentation either for an organisation's internal computer systems or for third party vendors.

Describe the various computer hardware that are required to create multimedia projects. -Technology

Description : Describe the various computer hardware that are required to create multimedia projects. -Technology

Last Answer : The answer can be drawn from the following CPU-The CPU of a multimedia computer should be at least 486 with math coprocessor. The Pentium processor is more efficient and is usually referred in ... touchscreen is used where the user is required to touch the surface of the screen or monitor.

Elaborate the various functions of Multimedia. -Technology

Description : Elaborate the various functions of Multimedia. -Technology

Last Answer : Various functions of Multi Media - can be used as a great support in planning and executing any project, can be used to explain or propose a concept, using multimedia while preparing content ... topic makes the process more organized and precise, the teaching and learning can be more interactive.

Evaluate the various functions of advertising. -Technology

Description : Evaluate the various functions of advertising. -Technology

Last Answer : Various functions of advertising are - it introduces a new product into the market, it helps distinguish a product from its competitors, through persistent message and associations, it creates a brand identity, it ... it creates new demand, it creates a buzz and keeps the idea of the product going.

What are the various modes of library acquisition? -Technology

Description : What are the various modes of library acquisition? -Technology

Last Answer : The various modes of library acquisitions are as follows:i. purchase;ii. Gift;iii. Exchange;iv. Online acquisition;v. Consortia based acquisition; andvi. Library consortia

What are the various ethical concerns that originate with the use of electronic text, multimedia sharing, and other on line resources? -Technology

Description : What are the various ethical concerns that originate with the use of electronic text, multimedia sharing, and other on line resources? -Technology

Last Answer : a. Digital material are prone to be misused easilyb. Ethical practices necessitate that the use of any digital materials, multimedia or online material be done as per the law of the landc. ... digital, multimedia or online resources of public domain is punishable offence, hence should be avoided.

Sharvan Joshi is a student of Political Science and is a keen researcher of Political issues related to various countries -Technology

Description : Sharvan Joshi is a student of Political Science and is a keen researcher of Political issues related to various countries -Technology

Last Answer : (a) Shravan should develop a blog.(b) Blogger.Com Wordpress.Com

A company in Mega Enterprises has 4 wings of buildings as shown in the diagram : Center to center distances between various Buildings: -Technology

Description : A company in Mega Enterprises has 4 wings of buildings as shown in the diagram : Center to center distances between various Buildings: -Technology

Last Answer : (i) Most suitable layout according to distance is :(ii) Star Topology(iii) Broadband.(iv). (a)Not required. Repeaters may be skipped as per above layout (because distance is less than 100 m)(b)In every wing(v) Radio Waves

What free website displays stock charts with automatic Support & Resistance indicators?

Description : What free website displays stock charts with automatic Support & Resistance indicators?

Last Answer : You can get pretty good customized charts from Yahoo Finance, but people don’t share their analysis for free. You have to do that work yourself.

Displaying dates on a PC using excel 2010 to create charts and graphs?

Description : Displaying dates on a PC using excel 2010 to create charts and graphs?

Last Answer : Never mind. I figured it out. If anyone else needs to know this is how you do it: you must enter the date in a different format. I originally entered the date by writing September 1 etc the computer ... entered 9/1 , 9/5 etc and this resulted in a simple display of the dates I enetered only!

Rage Against the Machine Vs Joe McElderry.... Is X-factor domination of the ********* charts a bad thing?

Description : Rage Against the Machine Vs Joe McElderry.... Is X-factor domination of the Christmas charts a bad thing?

Last Answer : I’ve purchased Rage! So have 4 of the lads around me in the workshop!

What is a good software package to make VERY quality charts and graphs to submit to academic journals (i.e., better than Microsoft Excel)

Description : What is a good software package to make VERY quality charts and graphs to submit to academic journals (i.e., better than Microsoft Excel)

Last Answer : If you’re on a mac, iWork ‘09 make some incredibly nice looking charts.

What are your thoughts on "ideal weight" charts?

Description : What are your thoughts on "ideal weight" charts?

Last Answer : They never take into account muscle mass or fat percentage. Take them with a pinch of salt, just as you should with BMI.

Why do natal charts sometimes contain contradictions?

Description : Why do natal charts sometimes contain contradictions?

Last Answer : Maybe because it’s just a lot of mumbo-jumbo?

Where can I find my local pond stock charts for fishing?

Description : Where can I find my local pond stock charts for fishing?

Last Answer : In Washington you can look in the paper on opening day, or sometimes sportng goods stores.