Re: Multiple Pieces of Information

From: Bernard V Liengme (bliengme_at_stfx.TRUENORTHca)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 14:16:20 -0400

Hi Lisa,
Because the range of the three sets of data (number, total cost, average
cost) are very different and because they are three very different things, I
would suggest you plot number and total cost.
Assuming row 1 has labels, A2:A13 has month values, B2:B13 has Number,
C2:C13 has Total$, D2:D13 Cost/call
1) Select A1:C13 and make a Column chart
2) On the chart, right click on the Total series, select Chart Type from
popup menu and make Line type
3) On the chart, right click on the Total series, select Format Data Series
from popup menu, open Axis tab and check Secondary Axis
4) On the chart, right click on secondary y axis, set max to 20,000 and
format as Currency with no decimals
Make other adjustments as needed
Come back if more questions

Best wishes
Bernard

"Lisa" <anonymous@discussions.microsoft.com> wrote in message
news:A4756AD5-17D7-4B3B-9C9F-1C3163988EEE@microsoft.com...
> I have been asked to create a chart which tells us how much we pay per
helpdesk call in any given month. I cannot for the life of me figure out how
to create a bar graph using more than two pieces of data. I woudlappreciate
any kick in the right direction. Maybe I am just not interpreting the data
from the right angle. Here is what I have:
>
> Months Number of calls Monthly $ Cost per call
> 1 9,835 $89,000.00 $9.05
> 2 11,256 $79,000.00 $7.02
> 3 10,568 $56,252.00 $5.32
> 4 7,582 $56,214.00 $7.41
> 5 12,235 $100,000.00 $8.17
> 6 9,002 $78,562.00 $8.73
> 7 11,256 $78,526.00 $6.98
> 8 10,895 $78,954.00 $7.25
> 9 10,756 $36,258.00 $3.37
> 10 9,952 $56,984.00 $5.73
> 11 10,849 $78,549.00 $7.24
> 12 11,259 $75,684.00 $6.72
>
> We want to be able to chart cost per call with all of teh given
information. Thank you!

Relevant Pages

  • Re: pie chart areas reflect magnitude
    ... You are right about the power and its influence on costs. ... Perhaps a stacked bar chart would be even more intuitive, ... If you want to display percentages and totals, ... constant or nearly constant costs plus a huge cost of power. ...
    (microsoft.public.excel.charting)
  • Re: pie chart areas reflect magnitude
    ... operating cost of each conveyor is a sum of: ... power: $343.56 ... You would see that the power is the vast majority of the cost for #2. ... Or think of it this way: a single discrete area of any one chart in any ...
    (microsoft.public.excel.charting)
  • Re: pie chart areas reflect magnitude
    ... A stacked bar chart is nearly as ineffective as a pie. ... While Conveyors 1 and 3 have a greater influence of parts and operator costs, power still makes up 89% and 92% of the total, compared to 96% for Conveyor 2. ... It's more a case of all conveyors having small constant or nearly constant costs plus a huge cost of power. ... Excel will give me the actual percentages of each cost component, but I want the 3 charts areas to be proportional to their totals. ...
    (microsoft.public.excel.charting)
  • Re: pie chart areas reflect magnitude
    ... I've put total dollars on the Total bars, and percentages on the others in this chart: ... While Conveyors 1 and 3 have a greater influence of parts and operator costs, power still makes up 89% and 92% of the total, compared to 96% for Conveyor 2. ... It's more a case of all conveyors having small constant or nearly constant costs plus a huge cost of power. ...
    (microsoft.public.excel.charting)
  • Re: adding second y axix
    ... Cost in C ... make chart ... Secondary Axis ...
    (microsoft.public.excel.charting)