software

DateEvent typeTotal
01-01-2006A10
01-01-2006B15
01-01-2006C12
02-01-2006A5
02-01-2006B7
02-02-2006C8
03-02-2006A5
03-02-2006B15

I would to generate a automatic stacked column (without having to make
manual selections) with the example above.The final result should be
the date in the x axis and the column composed by the event type
(A,B,C) with the respective total.
Note: the information is displayed as shown above.

How can i do this?

Thanks,
Regards
André--
vilacova
------------------------------------------------------------------------
vilacova's Profile: www.excelforum.com/member.php...oamp;userid=32709
View this thread: www.excelforum.com/showthread...hreadid=525390Select the data and create a Pivot Table (Data menu), with date in the rows
area, event type in the columns area, and total in the data area. Make a
chart from the pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;vilacovaquot; gt; wrote in
message ...
gt;
gt; Date Event type Total
gt; 01-01-2006 A 10
gt; 01-01-2006 B 15
gt; 01-01-2006 C 12
gt; 02-01-2006 A 5
gt; 02-01-2006 B 7
gt; 02-02-2006 C 8
gt; 03-02-2006 A 5
gt; 03-02-2006 B 15
gt;
gt; I would to generate a automatic stacked column (without having to make
gt; manual selections) with the example above.The final result should be
gt; the date in the x axis and the column composed by the event type
gt; (A,B,C) with the respective total.
gt; Note: the information is displayed as shown above.
gt;
gt; How can i do this?
gt;
gt; Thanks,
gt; Regards
gt; André
gt;
gt;
gt; --
gt; vilacova
gt; ------------------------------------------------------------------------
gt; vilacova's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32709
gt; View this thread: www.excelforum.com/showthread...hreadid=525390
gt;