Q: how to make stack bar chart with total values and a diamond marker for each column ?

[email protected]
-horizontal axis data: boy 1 boy2 boy3
-vertical axis min 0 max value
knw data: each boy took three test and test results are known
Max test score per test is 25 points.

Boy 1 test scores: 15, 22, 24
Boy 2 test scores: 20, 20, 25
Boy 3 test scores: 19, 20, 22

-I want to make a stack bar chart graping each score
-I kknow how to make stack bar chart
-I want each bar must be formatted in 3-D Format (I know to do this)
-I want a diamond shape marker on top of each column/stack bar
-I want the total value of the boys score on top of each stack bar

Hi Redwing99,

Welcome to the forums.

Looking at your request, there are issues.

1) You wanted a stacked bar chart, but it reads that it should be a column chart.

2) I wasn't able to create a combined chart in a 3-D. So I can't create a 3D stacked bar chart and combine it with a diamond marker. Does it have to be in 3D?

3) Also, if I create this in 2-D, I am not sure how high above the stack you want the diamond.

Take a look at this sample and let me know if it will work for you.

Adding Totals Above Stacked Column Chart.xls

Steve=True