Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 07, 04:39 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Needed: Chart that combines clustered column and stacked column types

The chart is to show projected financials for a business.

- Using Clustered Columns, I can show Revenue and Net Income. Not a
problem.
- Using Stacked Column, I can show the contribution to Revenue from
each of the businesses two product lines. Not a problem

What I would like to do is to combine these into a single chart: Show
a Stacked Column with the Revenue contributions and next to it
(Clustered Column) show Net Income.

Is this possible? If so, can you please explain how to do this.
Posting a simple example would be a bonus.

Many thanks.

gerry <at pairofdocs <dot net


  #2   Report Post  
Old February 13th 07, 10:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 11
Default Needed: Chart that combines clustered column and stacked column types

On Feb 13, 11:39 am, "Gerry" wrote:
The chart is to show projected financials for a business.

- Using Clustered Columns, I can show Revenue and Net Income. Not a
problem.
- Using Stacked Column, I can show the contribution to Revenue from
each of the businesses two product lines. Not a problem

What I would like to do is to combine these into a single chart: Show
a Stacked Column with the Revenue contributions and next to it
(Clustered Column) show Net Income.

Is this possible? If so, can you please explain how to do this.
Posting a simple example would be a bonus.

Many thanks.

gerry <at pairofdocs <dot net

@ gerry
There're at least two solution for your question.
(1)You could use second axis to solve this question. make a Clustered
Column in first axis and make Stacked column
in second axis.
(2) Just use the chart type of Clustered column, but rearrange your
souce data.
such as follows.
Jan
Fer Mar
Net Income. 10
12 14
Revenue contributions 1 4
6 9
Revenue contributions 2 6
6 5

Maybe you could find what you want in http://peltiertech.com/Excel/
Charts/ChartIndex.html
Good luck!
yours,fujing

  #3   Report Post  
Old February 13th 07, 07:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Needed: Chart that combines clustered column and stacked column types

Try the links on this page:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gerry" wrote in message
oups.com...
The chart is to show projected financials for a business.

- Using Clustered Columns, I can show Revenue and Net Income. Not a
problem.
- Using Stacked Column, I can show the contribution to Revenue from
each of the businesses two product lines. Not a problem

What I would like to do is to combine these into a single chart: Show
a Stacked Column with the Revenue contributions and next to it
(Clustered Column) show Net Income.

Is this possible? If so, can you please explain how to do this.
Posting a simple example would be a bonus.

Many thanks.

gerry <at pairofdocs <dot net



  #4   Report Post  
Old February 14th 07, 03:53 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Needed: Chart that combines clustered column and stacked column types

Thanks both - got it to work. Took a while to find the magic check box
so that things lined up just right...





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
Can I combine a stacked and clustered column chart in Excel Tim Donnelly Charts and Charting in Excel 7 October 8th 09 08:17 PM
Clustered stacked column Barb Reinhardt Charts and Charting in Excel 0 November 29th 06 10:44 PM
Combined: Clustered-Stacked Column Chart cdo Charts and Charting in Excel 1 August 31st 05 01:46 AM
combination clustered column and stacked bar chart John Charts and Charting in Excel 2 April 19th 05 03:49 PM
Clustered column chart with stacked coumns Dave Charts and Charting in Excel 1 January 4th 05 11:40 PM


All times are GMT +1. The time now is 01:29 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017