Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need help charting
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need help charting
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need help charting
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need help charting
Hi,
This is not something that lends itself to a pie chart. Personally I agree with Jon you should consider another chart type. For example you could make the Bid a line chart with the Hit a column. And you could display on the markers for the line chart. Now here is a solution that I personally don't like but... Choose a Radar chart type, using the second sub-type. Or use the 3rd subtype and turn off the fill color for the Bid series and increase its border weight and change its color. -- Cheers, Shane Devenshire "mgm" wrote: 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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need help charting
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting | Excel Discussion (Misc queries) | |||
Charting | Excel Worksheet Functions | |||
Charting help... | Charts and Charting in Excel | |||
Charting | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |