Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How Do You Graph A Ppf (production Possibilities Frontier) Chart .

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

View Answers     

Similar Excel Tutorials

Prevent Charts from Printing in Excel
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...
How to Create and Manage a Chart in Excel
In this tutorial I am going to introduce you to creating and managing charts in Excel. Before you create a chart yo ...
Combine Multiple Chart Types in Excel to Make Powerful Charts
In this tutorial I am going to show you how to combine multiple chart types to create a single chart in Excel. This ...
Changing Any Element in a Chart in Excel
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts ...

Helpful Excel Macros

Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within

Similar Topics

I have created a Pareto graph using the 'Large' & 'VLookup' formula.
So the graph takes the 1st to the last in order (to plot which is the highest loss) but I have a problem that if 1 or more Totals are the same, then the graph shows the total as the same name.
See below:

TOTAL TOTAL DAMAGE 62 Bagger 1 136 Bagger 2 71 Bagger 3 48 Bagger 4 68 Others 41 Production

BAGGER TOTAL Bagger 2 136 Bagger 3 71 Others 68 Bagger 1 62 Bagger 4 48 Production 41

Now when the top sheet has gathered the data required it displays them in its top order and creates a graph.
As you can see the top is Bagger 2, Bagger 3 and so on till the bottom = Production.
This gives me all that I rerquire when teh figures are all different but as you will see below it does not match on the graph when some figures are the same.
TOTAL TOTAL DAMAGE 62 Bagger 1 136 Bagger 2 71 Bagger 3 71 Bagger 4 68 Others 41 Production

BAGGER TOTAL Bagger 2 136 Bagger 3 71 Bagger 3 71 Others 68 Bagger 1 62 Production 41

The graph now should show the top as:
Bagger 2, Bagger 3, Bagger 4 and so on.
But as you can see it shows, Bagger 2, Bagger3, Bagger 3 and so on.

How can I show all the areas if the area is the same on more than one,

Hope this makes sense.


Hi there,

I'm glad i stumbled across this forum as I haven't been able to figure something out. I'm very new to excel, by which I mean i just started using it for the first time 3 days ago, but that hasn't stopped my work from giving me tons of things to do with the program. Anyways, i'm learning quickly but i;'m having difficulty figuring out how to make a graph which shows a workers production on the y axis and the quality on the x axis. However, instead of having two points on a standard xy scatter graph, I need a four quadrant graph that plots the worker (as a single marker on the graph) in one of the quadrants.

Basically i want any worker in the
upper right quadrant: to have high production and quality,
lower right quadrant: to have low production but high quality
lower left quadrant: to have both low production and quality
upper left quadrant: to have high production but low quality.

If anyone can shed some light on this you will make my workday much better.

First let me describe what I am trying to do.

Have a "spread range" (ie. 200-325, 330-455, etc.)filled down in columns that I want to graph as a Max, Min, Mid type chart. I tried to use a =LEFT(, =RIGHT( formula to draw only the characters that I needed, however, when i did this my graph stopped reading the values. Any reason why this might happen? Or are there any possibilities that I am missing to make this easier?

I can only assume that excel cannot graph these formulas, but usually I am assed. Please help!


I am in a production plant and want to track defects.
We have 2 shifts so I am entering data for each shift and I'm using the fomula =if((A1+A2)>0,A1+A2,NA()). I am using that data to create a line graph for each day and, if the cells are empty, I don't plot that point on the graph. If we run no production, we leave them blank and it doesn't plot...just like I want it to. Here's the kicker. If we run that day and have no defects, I want to be able to put zero's in the main table (say A1 and A2) and plot that as a zero day. I'm racking my brain trying to figure out how to do it. :x


I have a spreadsheet that I use to track production for a real estate team. One of the columns is the Source of their business (Referral, Sign, Website...etc) which is a drop down list.

I would like to create a pie chart or graph to show the percentages of where the Sources come from.

Please guide me. I am an Excel kind!

Thanks to any and all!!!


Capacity Production Capacity Production Capacity Production
Rockwool 100,000 65,000 0 0 200,000 120,000
Glasswool 600,000 320,000 1,000,000 970,000 2,500,000 2,400,000
Net earnings ($) 800,000 2,000,000 1,200,000
Market share Asia 5% 12% 1.2%
2007 Patents 8 23 190

I want to plot the above information of company A,B and C on one single chart in Excel. I tried many different formats but none are suitable to get al the information on one chart

Any Ideas guys?


How do I change this formula to represent a range? I want cells C2:C18, but I ran out of arguments - can't add any more. If DRC or Production shows in the column, I want the word "Outstanding" if not, I want the word "Completed".



I am trying to make a stacked bar graph that displays the coverage of items in my companies network. Each investment item is either covered or open, and either on target for budget, Above budget's target, or Under budget's target.

Thus I have a variety of possibilities for the data:

A) On Target -
B) Covered Under Target
C) Covered Above Target
D) Uncovered On Target
E) Uncovered Opportunity
F) Uncovered Risk

But since the data is grouped by covered and open I can only color the graph two separate colors, in two series, open and covered.

Is there a way to have multiple colors within the stacked bar graph based on the possible buckets it could fall in?

There is an attachment, I want the graph to look something like the red, gree, and yellow chart but right now I can only looking like the blue and yellow chart.

Please advise.

Thanks in advance.

My question, as exact as possible, although i'm not sure if this is even possible with VBA and excel.

But, it is very simple.

Instead of creating a chart with a TABLESET of data i create (the way everyone uses charts in excel),

I want to create a tableset of data from a CHART that i draw or the chart is the INPUT to a spreadsheet's data.


So, imagine opening an excel spreadsheet and seeing a monthly chart of production of widgets.
Then imagine clicking and dragging (ON THE CHART) next April's production up 20% from normal, and having this change the excel cell that refers to this point.

That is all.

The whole point of this is to use it as the front end to a complex spreadsheet, which will hopefully demonstrate how sensitive production and cost changes are to a business.

I'd like to have two of these charts in the same spreadsheet, which would feed data as inputs to my excel for costs, and the other for production.

-one other tidbit, the chart for "cost" should be represented as below the x axis (as a negative value). Production should be in individual units, and should of course be positive.

Please ask any questions for clarity. Thanks so much. I do hope you can help.

Tony Rogers

How to plot efficient frontier from sets of data containing expected return,
average return, variance, standard deviation, covariance and correlation ?

I have a graph that displays daily production. There are 2 shifts a day, so the graph has 14 different data points. There is also a constant target line.

Since the graph gets updated twice per day (at the end of each shift) I want to add a column graph on the right hand side showing the total production compared to the target. For example, if I have a target of 5 every shift, the total target for the week is 5*14 = 70. And if so far I have produced 4 and 2 on the first day and 5 and 3 on the second day, the total produced is 4+2+5+3 = 14. I want to add a column graph on the right side on a secondary axis showing the two values (14 and 70).

Any idea how to do this?

I attached a picture of the graph I have now.


Good morning.

I've done some searching through the forum and figured out how to create the Gantt chart I was looking for. I need to take it one step further, however. I want to be able to use the Gantt chart to view future year data. The chart currently displays 2008's final results. However, for certain items, the results will change by a certain percentage (not consistent across all items) in future years. For example, Item C may be in its third year for 2008, putting it at approximately 58% of its total potential production. I know that in its ninth year, 2014, it will be in full production. However, I also know that other items will be ending their production life within that time, creating gaps in overall production. I need to be able to see these gaps and plan ahead to fill them before they appear, so I need to be able to look at this Gantt chart and, given a table of production life for each item, be able to tell the Gantt chart I want to see results for 2014. Is this possible? Do I make sense?


I am pretty new to Powerpivot and therefore not sure how crazy of a request this is, but here goes.

On the attached spreadsheet on the Oil 7 Day Avg tab there is a pivot table and chart created using powerpivot. I need to remove all blank (zero production) data from this chart. The reason there is zero production data is because I have "Days" in the in the row label currently. I think this is what I need to replace with a new calculated measure but I am not sure how to do it or if that would fix it.

I want to remove all the blank production from each category and have the row labels 0 to the nth row.

The goal is to smooth out the chart. It is supposed to be non zero production(y) vs the number of days there was non-zero production(x) for each category.

Is this possible?

Hello all! I'm new to this forum and I'm kind of a hack in excel. I don't really know what I'm doing, but somehow I've been able to get it to do pretty much anything I've ever really wanted. Until now!

So what I would like to do is this:

1) I would like to use existing data to plot a graph curve. It will have the start date through end date of a production run, as well as number of units made each day.

This part I figured out: the next I can't seem to get.

2) I would like to enter a different size production run, and a different number of total units to create a new graph. This graph's shape is exactly proportional to the first.

* In other words, the second graph input is only the number of units and number of days-- I want to generate a rough prediction of how it will fluctuate assuming it will look like the first graph.

Any guesses?

I have one worksheet with manning data and another with production data. I want to show how some procedural changes have affected the efficiency of the department by comparing production per man hour. Can I use a pivot chart to draw from two different worksheets to group manhours and production by date?

I have set up data validation before, however, my employer is asking for something I don't understand.

"Add a data validation to the department column allowing for new entries to the table to have only 1 of the departments that currently exist in the table."
Tomorrow, I will be adding a new employee to the chart.

Can someone please help? I have been working on this all night, need to go to bed, go to work and have this figured out....

Department Accounting Accounting Accounting Accounting Administration Administration Administration Engineering Engineering Engineering HR HR Maintenance Maintenance Production Production Production Production Production Production Production Production QA QA Shipping

I'm wondering if it's possible to chart possibilities in two sets of data

fictional example:

Col A Rate:

Col B Base $ Value

So chart each row of A * each row B where a line in the chart starts with Ax*Bx and ends with Ax*By (in this example, 5 lines total)

I have set up data validation before, however, my employer is asking for something I don't understand. Excel 2007

"Add a data validation to the department column allowing for new entries to the table to have only 1 of the departments that currently exist in the table."
Tomorrow, I will be adding a new employee to the chart.

Department Accounting Accounting Accounting Accounting Administration Administration Administration Engineering Engineering Engineering HR HR Maintenance Maintenance Production Production Production Production Production Production Production Production QA QA Shipping

I have used the code below to specifically colour certain points in certain ways, problem is it doesn't affect the legend which remains showing the default colour, any ideas

Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(1).Points(1).Interior.ColorIndex = 6
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(2).Points(1).Interior.ColorIndex = 36
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(3).Points(1).Interior.ColorIndex = 4
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(4).Points(1).Interior.ColorIndex = 35
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(5).Points(1).Interior.ColorIndex = 5
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(6).Points(1).Interior.ColorIndex = 34
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(7).Points(1).Interior.ColorIndex = 7
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(8).Points(1).Interior.ColorIndex = 38
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(10).Points(1).Interior.ColorIndex = 28
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(11).Points(1).Interior.ColorIndex = 33
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(1).Points(2).Interior.ColorIndex = 6
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(2).Points(2).Interior.ColorIndex = 36

Does anyone know how to set up the formula for the efficient frontier in excel? I am used to using SPSS and I am not all that familiar with excel.

Greetings All...
A department manager wants to post charts of factory work center production performance as Windows Screen Savers. That idea has some interesting possibilities. While any number of methods could be used to generate the charts, using Excel allows the possibility that anyone could design a chart for their own area.

Basically we want to have windows run excel, load, calculate, and display the chart whenever it wants to display the screen saver.

Has anyone ever done something like this, or have any ideas or suggestions?


Using Excel 2007, and Windows 7.

Always something new, I guess; never had this before.

Have a chart as a Chart 1 tab on the bottom to which I add data once a week into Sheet 1.

Always worked just fine.

Today, when I clicked on the Chart 1Tab on the bottom to see the new graph, all my graph lines and curves have totally disappeared.
The x and y axes are still there, as are the axis labels.

But no graph. Totally wiped out.

What might have happened, please ?
All I did was simply click on the bottom tab that said Chart 1. Honest.

**How can I possibly get it back without having to go thru a whole new graphing
sequence ?

How do I prevent this from happening again ?

Was it something I (likely) did ?

Much Thanks,

I need help with a bar graph/chart. I have the chart almost complete I just need to add another set of data on the horizontal axis that is identical to the one already in it... I'd learn it myself but googling really doesn't help since the terminology for this stuff is so damn similar for everything.

Example of data:

Question 1 Reponse Percent
Yes 96%
No 4%
Question 2
Yes 95%
No 5%
Question 3
Yes 90%
No 10%

My problem is that I can't get the bar graph/chart to add Question 2 and 3 to the horizontal Axis. I have the bar graph/chart exactly the way I want it to look for Question 1 though.

I attached a copy of the excel file and the chart is open and ready to go.

Thanks in advance for advice.

Is there a way to edit text in a chart and link it to a value in a separate sheet? (without it being a value in the actual chart...) AND keep a line of text in the same box?

I have a chart, simple... 3 rows, 2 columns. But I need to edit an average in the chart each day, so I just manually divide and throw them on top of the chart in a text field. It changes daily, so I'm looking for a way to do this so it cuts back on some time. I can't figure out a clean way to put this information in the graph with the source data (it makes a graph out of the averages... I don't want that. Just the numbers on top of the existing graph).

Hi All,

I have a Excel chart which can plot daily power consumption again the production Qty. Now the excel chart start the plot time on X Axis from 00 Hr and end at 23:59 hour.

Now i need to change the start plot time on X Axis at 8:00 Am and end at 8:00 Am.

So that this way i can compare the Shift 1 and shift 2 production Qty ver power consumption. As during the 2nd shift the worker keep the machine running and production Qty is very low , this is because during 4 am till 5 Am usually production Qty low and power consumption remain the same.

Hope some one can help me.