Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
gordon_conroy
 
Posts: n/a
Default Combining stack column chart and non stacked


Hi All
Need to combine 2 charts
I have the Exp below in a stacked column chart and I can combine it
with Revenue as a line chart to view both of them together.My problem
is I want to see the Revenue as a column right beside the stacked
column

Cheers,
Gordon

yr1 yr2 yr3
Exp1 3 4 5
Exp2 1 2 3
Exp3 6 7 8

Revenue 5 20 10


--
gordon_conroy
------------------------------------------------------------------------
gordon_conroy's Profile: http://www.excelforum.com/member.php...fo&userid=5498
View this thread: http://www.excelforum.com/showthread...hreadid=493775

  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Combining stack column chart and non stacked

Hi,

Stacked cluster charts can be created by careful layout of your data.
Jon Peltier has details
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

gordon_conroy wrote:
Hi All
Need to combine 2 charts
I have the Exp below in a stacked column chart and I can combine it
with Revenue as a line chart to view both of them together.My problem
is I want to see the Revenue as a column right beside the stacked
column

Cheers,
Gordon

yr1 yr2 yr3
Exp1 3 4 5
Exp2 1 2 3
Exp3 6 7 8

Revenue 5 20 10



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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



All times are GMT +1. The time now is 04:03 PM.

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

About Us

"It's about Microsoft Excel"