mgm -

If you are interested in showing the relationship between HIT and BID for
each company, you could use an XY (Scatter) chart type.

For example, if you want to see how HIT depends on BID, your XY (Scatter)
chart would have BID on the X axis and HIT on the Y axis.

Also, you could use the add-in from
www.appspro.com/Utilities/ChartLabeler.htm to label each of the five points.

And, if you want to compare how close the HIT is to the BID, you could add
another XY data series with a line connecting point (0,0) with point
(1000,1000).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"mgm" wrote in message
...
Hi, Thanks for your response. For example

5 companies, hit and bid
HIT BID
Mgm 1 400.00 300.00
mgm2 1000.00 500.00
mgm3 600.00 600.00
mgm4 850.00 850.00
mgm5 900.00 900.00


I would like to show in a pie or graph by vendor hit,bid

Thanks
"ShaneDevenshire" wrote:

Hi,

Don't know what a cost hit is? Maybe you can show us some sample data
and
tell us what kind of chart you need - pie, line, column....?

--
Thanks,
Shane Devenshire


"mgm" wrote:

I am new to charting. I need to chart 5 different companies with a
cost bid
and a cost hit by company. Can you explain how. Very confused.

Thanks.