Stacked columns .... continue

[Julie]

Good day everybody,

Sorry that my message was not completed. Here is my question and situation.
I am trying to do a bar chart.

Here is my test data.
Expenses Sales Commission Royalty
Product A 20 100 10 5
Product B 30 200 20 10

I have put Expenses in first Axes. And Sales, Commission and Royalty are
stacked on second axes.This has worked well.
Except that I would like to see the maximum value for the stacked column as :
e.g Product A = 100 instead of 100+10+5 i.e. 115
This means Sales, Commission and Royalty are overlapping each other instead
of above each other.

I will appreciate if anyone can help me.

Thank you in advance.

Best regards,
Julie

 

[Jon Peltier]

Julie -

I didn't see this until now, when I answered your other incomplete question.

all you need to do is insert a column into your data, which has a
formula to subtract Royalty and Commission from Sales, and plot this
column instead of Sales.

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

 

[Julie]

Thank you, Jon.

That is a good solution.
However I need to show the figure/value in the chart.
My Sales will be display the wrong value i.e. 100-10-5=85 instead of 100.
Any other way to work around it?

Thank you and have a nice day.

Best regards,
Julie

 

[Jon Peltier]

Julie -

I have an answer for everything! Download Rob Bovey's Chart Labeler
(http://appspro.com) or John Walkenbach's Chart Tools
(http://j-walk.com). These are free addins that make it easy to use data
from any cells for your data labels. So use the data in the 85 column
for the column size, and data from the 100 column for the labels.

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

 

[Julie]

Thank you again, Jon.

You are right, you seems to have answer for everything.
I will download the two addins and try them out.

Have a wonderful weekend.

Best regards,
Julie