In: Business and Management

Submitted By arifmahmood
Words 1424
Pages 6
Combining Chart Types, Adding a Second Axis
Today’s author: Katherine Fifer, an intern on the Excel team. Katherine is just wrapping up a summer of fantastic work, and today she is going to discuss how to create a combo chart in Excel 2007.

Often it is useful to create charts which compare different types of data. For example, you might want to compare share price with trading volume, or revenue with number of units sold, or poverty rate with unemployment and consumer confidence, or any number of other things.

To quickly and clearly display data of different types, it can be helpful to plot some data series either with different chart types, on different axes, or both. Let’s look at an example.

Suppose I work at a manufacturing company and I’d like to analyze the number of units we’ve sold over the last few months and the total dollars sold each month. I’m hoping to identify trouble spots, such as high unit sales but low dollar transaction amounts, which may indicate that the units are being discounted too deeply.

I could make two different charts – one plotting units sold by month, and one plotting transaction dollars by month. However, it will be challenging to analyze the two charts separately. I’d much rather create a chart like the one pictured below.

With the right helpful hints, it turns out that making this kind of chart isn’t too tough. First, I’ll walk through the two major steps (changing series chart types, and adding an axis) and then I’ll describe how to put the finishing touches on this chart.

STEP 1: So that we’re on the same page, I’m starting with the following simple data set:

I could also format this as a table by simply clicking “Format as Table” on the Home tab of the ribbon and choosing any of the styles. By setting up a…...

Similar Documents

Lecturer Career

...TINGKATAN 1 Tanah Pamah  Dataran  Lambah  Lembangan  Delta  Paya Tanah Tinggi  Gunung lipat muda  Gunung lipat tua  Banjaran  Dataran tinggi BENTUK MUKA BUMI Hakisan Ombak  Tebing tinggi  Tanjung  Gua  Teluk  Gerbang laut  Batu tunggul  Batu sisa Pola Sungai bawah tanah Pinggir Laut Mendapan ombak  Pantai  Anak tanjung/tetanjung  Beting pasir  Tombola  Lagun SALIRAN reranting jejala sepunca (jejari) sejajar bersirat saliran darat (pola berpusat) Struktur batuan sama keras di kwsn batu mendak Batuan keras lembut Mengalir semua arah berselang dari kwsn seli tanah tinggi Anak sungai Di kwsn bercantum batu dengan anak kapur sungai utama yang poros Banyak alur cth: delta Sungai mengalir ke tasik PROFIL SUNGAI Hulu lurah ‘V’ air terjun lubang periuk jeram Tengah likuan sungai lurah ‘W’ dataran mendap tasik ladam Hilir tetambak delta (aluivium) JENIS-JENIS BENTUK MUKA BUMI DAN POTENSI / KEPENTINGAN Bentuk Muka Bumi Tanah Tinggi Cerun Bukit Sungai Potensi / Kepentingan -Pelancongan Pertanian Pengangkutan -Pertanian hawa sederhana Malaysia -Cameron Highland -Sayur dan bunga sabah dan sarawak -Kundasang (cameron highland) (Mengangkutan -getah dan kelapa sawit penumpang dan kayu (cerun bukit) balak) Luar Malaysia Switzerland Jawa Indonesia Thailand (Chao phraya) (meluncur salji dan Meluas / lava bes (padi) mendaki gunung) Tasik Perikanan -kurang penting -saiz kecil -tangkapan sedikit -aktiviti sambilan Tonle sap (Kampuchea)......

Words: 2422 - Pages: 10


...Unit 2: ROLES AND RESPONSIBILITIES AND RELATIONSHIPS IN LIFELONG LEARNING 1.1. Summarise key aspects of legislation, regulatory requirements and codes of practice related to own role and responsibilities. It is important for all teaching staff and any educational establishment where teaching and training take place keep up to date with all relevant Legislations and Code of practice to ensure they are remaining current with their knowledge and skills, and with any relevant changes or updates that have taken place (Harris 1999). However these will differ depending on the subject, the context and environment within which teaching takes place. These legislations include: • Equality Act (2010) brings disability, sex, race and other grounds of discrimination within one piece of legislation. The Act provides rights for people not to be directly discriminated against or harassed because they have an association with a disabled person or because they are wrongly perceived as disabled. The Act ensures all people are treated equally regardless of their race, sexual orientation, religion and belief, maternity and pregnancy, marriage or civil partnership. • The Data protection Act 1998 is to make provision for the regulation for the processing of information relating to individuals, including the obtaining, holding, use of disclosure of such information. The Human Right Act 1998 is meant to give people the right and freedom to live the way they choose to be. ...

Words: 2581 - Pages: 11

Assist Lecturer

...BIBLIOGRAPHY Abu-Ruqayeq, A. M. (2000). A Contrastive Study of Time Adverbials in English And Arabic, Unpublished M.A. Thesis. University of Jordan. Adams, V. (1973). An Introduction to Modern English Word-Formation, London : Longman. Al-Dahdah, A. (1988). Mu'jam Mustalahat Al-I'rab Wa Al-Bina'a Fi Qawa'd Al-Lugha Al-Arabia Al-Alamia, Beirut: Maktabat Lubnan. Alexander, L. G. (1988) Longman English grammar, London: Longman. Alexiadou, A.; Haegeman, L. and Stavrou, M. (2007). Noun Phrase in The Generative Perspective, Berlin: Mouton de Gruyter. Algeo, J. (1971). "The voguish uses of non". American Speech. 46, 87-105. Allerton, D. J. (2002). Stretched Verb Constructions in English, London and New York: Routledge. Anderson, S. R. (1992). A-Morphous morphology, Cambridge: Cambridge University Press. Anderwald, L. (2004). The Varieties of English Spoken in The Southeast of England: Morphology and Syntax, In: Kortmann, B.; Burridge, K.; Mesthrie, R.; Schnieder, E. W. and Upton, C. (2004). A Handbook of Varieties of English: A Multimedia Reference Tool, Berlin: Mouton de Gruyter. Andrews, E. (1986). "A synchronic semantic analysis of de- and un- in American English", American Speech 61, 221–232. Aremo, B. (2005). " Nouns Illustrating Adjective-Noun Conversion in English", Asian EFL Journal 7 (1) 1-12. Aronoff, M. (1976) Word formation in generative grammar, Cambridge: (Mass.): MIT Press. Aronoff, M. and Fudeman, K...

Words: 1787 - Pages: 8


...Strategic Management Case plus Case Answer – Apple’s Profitable but Risky Strategy Case study Apple’s profitable but risky strategy When Apple’s Chief Executive – Steven Jobs – launched the Apple iPod in 2001 and the iPhone in 2007, he made a significant shift in the company’s strategy from the relatively safe market of innovative, premium-priced computers into the highly competitive markets of consumer electronics. This case explores this profitable but risky strategy. Note that this case explores in 2008 before Nokia had major problems with smartphones – see Case 9.2 and Case 15.1 for this later situation. Early beginnings To understand any company’s strategy, it is helpful to begin by looking back at its roots. Founded in 1976, Apple built its early reputation on innovative personal computers that were par-ticularly easy for customers to use and as a result were priced higher than those of competitors. The inspiration for this strategy came from a visit by the founders of the company – Steven Jobs and Steven Wozniack – to the Palo Alto research laboratories of the Xerox company in 1979. They observed that Xerox had developed an early version of a computer interface screen with the drop-down menus that are widely used today on all personal computers. Most computers in the late 1970s still used complicated technical interfaces for even simple tasks like typing – still called ‘word-processing’ at the time. Jobs and Wozniack took the concept back to Apple and developed......

Words: 7002 - Pages: 29

The Impact of Nonverbal Communication Cues Used by Lecturers During Lectures

...THE IMPACT OF NONVERBAL COMMUNICATION CUES USED BY LECTURERS DURING LECTURES A CASE STUDY OF DR MFON ITEK and MR MIKE IGIRI WRITTEN BY EKPO, YVONNE UWEM 10/AR/CA/661 AKPAN, EDIDIONG ANIEDI 10/AR/CA/640 SUBMITTED TO DR ITA EKANEM LECTURER-IN-CHARGE COM317: CASE STUDIES IN COMMUNICATION ARTS DEPARTMENT OF COMMUNICATION ARTS FACULTY OF ARTS MARCH, 2013 INTRODUCTION Nonverbal communication is behavior, other than spoken or written communication, that creates or represents meaning. In other words, it includes facial expressions, body movements, and gestures. Nonverbal communication is talking without speaking a word. It is very effective, maybe even more so than speech. Remember the saying, “Actions speak louder than words” or “a deafening silence” You may be surprised to know that not only humans respond to this kind of communication. If you have a pet, especially a dog, it may follow directions and respond to hand and body movements more than your words. Dogs will even get confused if you say “sit” but give the hand motion that you usually use for “stay”. There are two main types of nonverbal communication, the body language and the gesture. Body language: Body language is body movements that depend on a person’s attitude or feelings. Body language includes the way people walk, how they stand, and their facial features. In other words, any kind of meaning that is shown by a person's body attitude or movements. For example, when a student......

Words: 2074 - Pages: 9


...Tell Me About Yourself" The Toughest Question in the Interview Don Straits, CEO and Dragon Slayer, Corporate Warriors  Share This Post When you, as a job seeker, are asked the most common, and toughest, interview question, "Tell me about yourself," your answer can make or break you as a candidate. Usually job seekers will respond with their "30 second commercial," and then elaborate on their background. While almost every career book and career counselor will tell you that is the appropriate response, I totally disagree. Many people fail in their job search because they are too often focused on what they want in a job including industry, type of position, location, income, benefits, and work environment. Their "30 second commercial" is centered around this premise. The commercial describes the job seeker's career history and what they are looking for. Too often, this is in direct contrast to what employers are looking for. There are two dominant reasons why job seekers are successful in the job search. The first is focusing on the needs of the organization. The second is focusing on the needs of the people within that organization. In this article, we are going to examine how to focus on the needs of the people within organizations. This will assist in rethinking your response to that all-important question, "Tell me about yourself." In order to learn how to respond to the needs of the interviewer, let's first learn more about ourselves. We can then apply that......

Words: 1376 - Pages: 6


...Name Instructor Course Date Cultural Factors and Customs Australia is an island continent with six states namely Queens Land, Victoria, South Australia, Tasmania, Western Australia, and Wales. Most people live in the urban areas especially around the coastal regions. The capital cities automatically are also six namely Darwin, Brisbane, Canberra, Perth, Adelaide and Melbourne. Excluding Tasmania, Australia covers approximately an area of about 7.6 million square kilometers. The social aspects in Australia are highly valued since they act as the unifying factor in the country they include, language, religion, arts and the sporting culture (Frankie, 171). The social aspects determine the future of the country both economically, socially, and politically. Language is the first aspect; many people are urged to learn the national language which is English and also a unifying factor among the people. There are also a variety of other languages that are used in Australia such as Greek and Vietnamese. Another aspect is that of religion, where most of the citizens in Australia are Christians by religion. Australia is recognized as a nation with a wide cultural diversity due to the many religions practiced. The earliest religions date way back to the islander people who existed around 60, 000 years ago. There is no official rule in the nation that restricts people from practicing any religion as long as they respect the law. Australia is also famous for its vibrant and fine art......

Words: 1234 - Pages: 5

Senior Lecturer in Finance and Accounting

...SFM400 Strategic Financial Management M.G.W. Kachanje Senior Lecturer in Finance and Accounting Definition of 'Strategic Financial Management ' Managing an organization's financial resources so as to achieve its business objectives and maximize its value. Strategic financial management involves a defined sequence of steps that encompasses the full range of a company's finances, from setting out objectives and identifying resources, analyzing data and making financial decisions, to tracking the variance between actual and budgeted results and identifying the reasons for this variance. The term "strategic" means that this approach to financial management has a long-term horizon At the most fundamental level, financial management is concerned with managing an organization's assets, liabilities, revenues, profitability and cash flow. Strategic financial management goes a step further in ensuring that the organization remains on track to attain its short-term and long-term goals, while maximizing value for its shareholders. Strategic financial management also means that short-term goals may occasionally need to be sacrificed to meet longer-term objectives. A typical example is when a loss-making company trims its asset base through factory closures or headcount reduction in order to reduce operating expenses. While such actions have a detrimental effect on near-term results because of restructuring costs and other one-time items, it positions the company to......

Words: 4316 - Pages: 18


...Competitive Advantage for Green Marketers (http://parkhowell.com/green-advertising-and-marketing/the-15-minute-competitive-advantage-for-green-marketers) Green Marketing- Concepts and Cases By  Suresh K 4. Article on GREEN MARKETING – OPPORTUNITIES & CHALLENGES  BY Miss. P. PIRAKATHEESWARI, 5. Green Marketing: How It Works and When to Use It by Emily McClendon,Environmental Marketing Specialist Marketing Strategies for Green Business for sustainable future Presented by, V. ARAVIND K. M. UDAY RAJ B2B Green Marketing and Innovative Theory for Competitive advantages by Valerie L Vaccaro Author Prof. Porinita Samanto Banerjee (Lecturer) M.com, MBA, M.phil Mob:09561436839 Prof. Manisha Jagtap (Lecturer) M.Com, MBS Mob: 09823030880 Prof. Payal Samdariya (Lecturer) M.Com, MBA Mob: 08055150706 Institute Name: Aki’s Poona Institute of Management Sciences and Entrepreneurship Poona college campus, Camp, Pune-411001 Ph: 020 2644 8781 / 2643 3702...

Words: 1931 - Pages: 8


...Pitching (1.) Who to target: initial target market, customer need/job, and market size estimate (zeros)  From the African economic outlook report of 2014, Cameroon has shown a strong prospect of economic growth. With a stable political and economic atmosphere, the business environment is very conducive and has already set a pace for economic growth and investment. Looking at the consulting sector, it is a very large industry with plenty of opportunities to explore. We have carried out a number of studies on the Business environment, and target market segment we would be focusing on. Here are our target Market: 1. The government; The government of Cameroon has as of 2013 engaged in a number of investment programs. With expansion in the agricultural sector topping the list, this is expected to create a multi-billion dollar industry. The government is currently seeking for firms and corporations to work with in other to achieve is 2035 goals. According to the African economic outlook report, investment in energy is also top in the government’s agenda, road and other infrastructural development are also a priority. 2. Other Multinational consulting Firms. We are putting into place every mechanism to work with other multinational consulting firms. This is a very important target because, most of the multinationals look for opportunities to work with smaller local consultants for the obvious reasons of their knowledge of the business environment. Outsourcing......

Words: 1183 - Pages: 5


...MAKERERE UNIVERSITY COLLEGE OF HUMANITIES AND SOCIAL SCIENCES SCHOOL OF SOCIAL SCIENCES DEPARTMENT OF POLITICAL SCIENCE AND PUBLIC ADMINISTRATION AN INTERNSHIP REPORT ON FIELD ATTACHMENT AT MASINDI DISTRICT LOCAL GOVERNMENT FROM 12th JUNE 2014 TO AUGUST 12th AUGUST 2014 BY TUGUME TRAVER 12/U/14775/EVE FIELD ATTACHMENT REPORT SUBMITTED TO THE COLLEGE OF HUMANITIES AND SOCIAL SCIENCES IN PARTIAL FULFILMENT OF THE REQUIREMENTS FOR THE BACHELORS DEGREE OF ARTS IN SOCIAL SCIENCES OF MAKERERE UNIVERSITY KAMPALA STUDENT’S NAME: TUGUME TRAVER SIGNATURE: ………………………….… UNIVERSITY SUPERVISORS NAME……………………………. SIGNATURE………………………… FIELD SUPERVISOR’S NAME; …………………………….. SIGNATURE; ……………………….. DECLERATION I Tugume Traver declare that i have carried out this field attachment and the content of this field report is my original work and an authentic report that has never been submitted to any institution. It’s now being presented as partial fulfillment of a bachelors of arts in social sciences at Makerere University. Signature…………………………. Name………………………… ...

Words: 4349 - Pages: 18

Croatian Perspective(S) on the Lecturer-Student Interaction Through Social Media

...CROATIAN PERSPECTIVE(S) ON THE LECTURER-STUDENT INTERACTION THROUGH SOCIAL MEDIA Nikola Draskovic, PhD Zagreb School of Economics and Management Jordanovac 110, HR-1000 Zagreb, Croatia ndraskov@zsem.hr Martina Caic, MBA Zagreb School of Economics and Management Ana Kustrak, MA, MBA Zagreb School of Economics and Management Abstract During the last decade, the application of social media in the context of higher education emerged from an informal means of communication to a strategic educational tool. Social media offers the possibility to create and share various content through web related applications. Furthermore, it is a communicational platform and a tool, which could be used for interpersonal communication, information exchange, and discussion over a range of topics. This qualitative study provides limited insight into the usage of social media in formal/informal learning/teaching and for the interaction between a student and a lecturer in the context of Croatian higher education. Through a series of in-depth interviews with both undergraduate students and lecturers, the current practice and behaviour related to the use of social media is investigated. As was expected, various types of social media are generally more popular among students, while among of the lecturers social media is usually considered an informal medium whose role in Croatian higher education has yet to be defined. This study revealed the usage and attitudes towards social media......

Words: 4009 - Pages: 17


...ANALYSIS OF A COMPANY’S LIQUIDITY BASED ON ITS FINANCIAL STATEMENTS Pacurari Doina Universitatea din Bacau, Facultatea de Stiinte Economice, Bacau, str.Spiru Haret nr.8, E-mail doinap_ro@yahoo.com, Telefon 0740 179097, Muntean Mircea Universitatea din Bacau, Facultatea de Stiinte Economice, Bacau, str.Spiru Haret nr.8, E-mail doinap_ro@yahoo.com, Telefon 0740 223535 Abstract: The liquidity characterise the financial situation of the company, its ability to convert assets into cash or to obtain cash to meet short-term obligations. Lack of liquidity may affect seriously the continuity of the company activities. Computation and analysis of the liquidity are made by a system of ratios based on the data within the financial statements. An absolute value of a liquidity ratio is not relevant. For a correct analysis of the company’s financial situation more liquidity ratios have to be considered and their trend also. Key-words: liquidity, ratio, analysis, financial statements Introduction The fundamental source of the bankruptcy risk consists in the insolvency of the company. Solvency is represented by the capacity of the company to cover all its obligations that result either from previous contracts or from current operations. Solvency must be analysed on short-term (liquidity), as well as on long-term. Thus, liquidity expresses the capacity of the company to meet its short term obligations, that is, to cover its cash outflows with adequate cash inflows and, moreover, to ensure...

Words: 3390 - Pages: 14

Lecturers’ Competencies: a Case Study in International Universities

...This paper is submitted to & accepted in SEMILOKA NASIONAL “Better Management to Support Good Corporate Governance” Departemen Manajemen, Fakultas Ekonomi dan Manajemen, Institut Pertanian Bogor, September 16, 2006 LECTURERS’ COMPETENCIES: A CASE STUDY IN INTERNATIONAL UNIVERSITIES Sam PD Anantadjaya ETC & Foundation, Bandung 40198, Indonesia bmw@bdg.centrin.net.id Irma M. Nawangwulan English Tutorial Center, Bandung 40161, Indonesia englishtutorialcenter@yahoo.com Abstract The presence of well-known universities outside Indonesia has attracted significant interests, not only from Indonesian residents, but also from residents of other countries. Particularly, western universities are highly demanded and the competition is rather fierce when students attempt to register and take on the entrance tests. Only the top percentile of students seems to be accepted. Because of limitation in space and personnel, those western universities decided to expand their market base into developing countries by getting closer to their potential customers. International universities have become a new trend in Indonesia’s higher educational institutions. With the growing numbers of students applying into the international programs at various universities in Indonesia, it is apparent that Indonesians are more assertive to receive internationalized standards. Thus, matching consumer behaviors and expectations in the local market would be indispensable in trying to ensure the smooth......

Words: 3194 - Pages: 13


...Research proposal Consumer choice of service provision in services industries Birgit Rettinger Author: Dipl.-Kffr. Birgit Rettinger Doctoral Student ESCP-EAP European School of Management Berlin Chair of Marketing (Prof. Dr. Frank Jacob) Heubnerweg 6 14059 Berlin Germany T: ++49 (0) 30 / 3 20 07-129 F: ++49 (0) 30 / 3 20 07-118 birgit.rettinger@escp-eap.de I. Introduction In the past decade the range of service provision modes in services industries has increased considerably especially as information technology got increasingly sophisticated. Accordingly, the phenomenon of multiple service provision options, owned by one company and providing similar services simultaneously is relatively new (Neslin et al. 2006). Moreover, modified consumer habits and lifestyles have led to altered attitudes concerning modes of service provision. At the same time, there has be a growing call for a paradigm shift to customer focus and value creation (see for instance, Sheth and Sisodia 2003). In line with this, the notion of the consumer‟s part in value creation has changed. Consumers now are seen as actively involved in creating value instead of being only passive responders (Beckett and Nayak 2008; Vargo and Lusch 2004; Xie et al. 2008). II. Statement of the Problem and Purpose of the Study The research is intended to focus exclusively on the consumer‟s perspective concerning the choice of service provision in services industries. This is regarded as......

Words: 4098 - Pages: 17

Temporada 1 | Falling Skies (2011) | HD Kids Baking Championship