Thread: Stacked Column Chart

Date Event type Total
01-01-2006 A 10
01-01-2006 B 15
01-01-2006 C 12
02-01-2006 A 5
02-01-2006 B 7
02-02-2006 C 8
03-02-2006 A 5
03-02-2006 B 15

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é

Select 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 -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"vilacova" <vilacova.2533kp_1143052804.212@excelforum-nospam.com> wrote in
message news:vilacova.2533kp_1143052804.212@excelforum-nospam.com...
>
> Date Event type Total
> 01-01-2006 A 10
> 01-01-2006 B 15
> 01-01-2006 C 12
> 02-01-2006 A 5
> 02-01-2006 B 7
> 02-02-2006 C 8
> 03-02-2006 A 5
> 03-02-2006 B 15
>
> 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:
> http://www.excelforum.com/member.php...o&userid=32709
> View this thread: http://www.excelforum.com/showthread...hreadid=525390
>