Economic Charts

F

Frustrated Student

Hi,
Does anyone know if I can use Excel to calculate economic charts such as
Production Possibility Frontiers and Comparative Advantage charts. If so
could you please let me know how.

Many Thanks
A Frustrated Student
 
J

Jon Peltier

Each chart needs some X values and Y values, no matter how fancy the name of the
chart. If you have some input data, and a relationship between these and the values
being plotted, put the inputs into various columns. In the next two columns, put
worksheet formulas into the cells to calculate X and Y from these inputs. Then
select these two columns of data, start the chart wizard, and follow instructions to
make a column chart or an XY Scatter chart (which is what most people want when they
say Line chart).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top