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


---
Message posted from http://www.ExcelForum.com/

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

In article <(E-Mail Removed)>,
fatmaninspeedos <<(E-Mail Removed)>>
says...
> 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
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>