Stacked Column on single column

[Julie]

Good day everybody,

I would like to show four figures in one chart.
I have use two-axes bar chart.
Example, Expenses Sales Commission Royalty
Product A 20 100 10
Product B 30

 

[Jon Peltier]

If you just plot the data you have posted as a stacked bar chart,
Product A would have three items stacked on it, and Product B would have
1, because the other two have zero value.

Is this what you want?

- 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