Combine bar chart with stacked chart

G

gatorooski

I want to combine a stacked chart with a bar chart in one chart. For example,

domestic sales $1,000
international sales $2,000
intercompany sales $3,000

On one chart I want;
3 bars which show the above data separately
1 stacked bar which shows the data striated between the three sales figures
(different colors for each sales number)

I can't seem to do it. I have excel 2003 and excel 2007.
Thank you to anyone in advance who can help me
 
X

x

Hi,
If its a once off I suppose you try this, its not a very elegant solution a
bit of a hack acutally
A1= Domestic A2= 1000
B1= International B3=2000
C1= Internal C4=3000
D1= Total D2= sum(A2:C2) fill to D4
Select A1:D4 and select stack chart.

Hope this help

-regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine two different chart styles on one chart 1
sideways stacked bar charts with line series on the same axis 0
Stacked Bar Chart 1
Combination Column and Stacked Column Chart in XL 2007 1
Bar Chart with Data Elements 1
How can I combine a stacked column chart and line chart? 1
Multiple stacked clustered bars 1
actual vs plan chart 0

Top