Elasticities and secondary axis graphs, Microeconomics

Create a chart with a secondary vertical axis to plot related data series with different scales.

Use the Combination Chart Fashion worksheet to create and format a combination chart exactly as illustrated in the picture provided in the Excel worksheet.  The two data series are net income and total assets.

First create a 2D column chart of total assets.  Please enter the series name.

Second click the active chart area to make it active then right click to get the menu, choose select data, and then add the net income as a data series.  Please enter the series name.

Also, add the fashion company names to the horizontal axis using the select data menu.

Third, you can plot data on a secondary vertical axis one data series at a time. In the chart, left click the data series that you want to plot on a secondary vertical axis in this case net income. In the design tab choose change chart type.  Find and select the option line with markers.

When the line is entered into the graph, left click on the net income line to make it active.  Make the layout menu tab active.  In the current selection box, select format selection, series option and select secondary axis. The secondary axis should be displayed.

Now, format the axis to the desired scale.  Left click on the left axis to make it active, right click and select format axis.  Choose the fixed options and use 0, 10000, and 2000 for minimum, maximum and major unit, respectively.

Calculate the Return on Asset (ROA) for each firm (using the appropriate formula listed below in cells B37, C37, D37, and E37. Format with a % sign). Using the ROA, rank the firms from highest to lowest. Why might a manager care about ROA?

Posted Date: 4/12/2013 3:45:19 AM | Location : United States







Related Discussions:- Elasticities and secondary axis graphs, Assignment Help, Ask Question on Elasticities and secondary axis graphs, Get Answer, Expert's Help, Elasticities and secondary axis graphs Discussions

Write discussion on Elasticities and secondary axis graphs
Your posts are moderated
Related Questions
When is the price of a product demand determined? The price of a product is demand defined while the product is in fixed supply. This means that the price of the product is defin

#how do you draw a demand curve on excel

How we constract the cost structure of firms

What are the economic implications of income inequality? How can economic theory be helpful to analyze the causes and impact of income inequality? What are the concerns and how the

Dependence on agricultural production: Dependence on agricultural production and primary product for exports. The external sector comprises Imports and Exports, Ghana shows de

The price elasticity of demand is how economists calculate the responsiveness of consumers to alters in prices for a commodity.  In other words, as price enhances (reduces), the qu

How is the wrong conclusion result in necessary condition not in the sufficient condition? This is often heard that the market institution must not be used based onto the fact

Economic Value to Customer Economic Value to Customer = EVC x = [LifeCycle costs of a competitor's product in relation to a home firm] - [Start-up Costs for the home fir

On Valentine's Day, the price of roses increases by more than the price of greeting cards.  Why? (Hint: Consider what makes roses and cards different and how that difference might

some fields have large enough quantities of both oil and ntural gas taht coordination must be achieved for the production of both, reather than oil alone as in our examples. will f