Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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é -- vilacova ------------------------------------------------------------------------ vilacova's Profile: http://www.excelforum.com/member.php...o&userid=32709 View this thread: http://www.excelforum.com/showthread...hreadid=525390 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining stack column chart and non stacked | Charts and Charting in Excel | |||
Stacked Column Chart | Charts and Charting in Excel | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel | |||
Stacked column and column combo chart | Charts and Charting in Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel |