View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default I need help charting

I can't imagine a pie would make any sense for this data. Try a clustered
column chart. You should have your MGMx labels across the horizontal axis,
with side by side columns for HIT and BID.

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


"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.