charting flight loads

  • Thread starter Thread starter fatmaninspeedos
  • Start date Start date
F

fatmaninspeedos

I have the task of charting daily flight information, but I'm having
issues charting some of the data. A sample dataset looks like the
following

Flight / Time / Customers
618 / 7:00 / 123
66 / 7:00 / 56
12 / 7:15 / 12
728 / 8:30 / 232
96 / 10:00 / 183
(many more flights)

When I graph using the XY Scatter (or simple Line Graph), excel puts 2
values for 7:00 when I want it to show one value (123 + 56 = 179). The
end result would be an x-axis that behaves like an XY Scatter, but adds
up the data for me.

What do I need to do to acheive this effect?

-- Aaron
 
Use a PT to have XL sum data within specified groups. The Time would
be a row field and the Customers would be a data field. Ensure XL uses
'Sum of Customers' rather than 'Count of Customers'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top