Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
vilacova
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining stack column chart and non stacked gordon_conroy Charts and Charting in Excel 1 December 15th 05 03:48 PM
Stacked Column Chart Stacy Charts and Charting in Excel 1 June 28th 05 05:52 PM
combination clustered column and stacked bar chart John Charts and Charting in Excel 2 April 19th 05 03:49 PM
Stacked column and column combo chart KG Charts and Charting in Excel 5 March 16th 05 03:01 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 05:31 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"