Data Points within a stacked column chart

**DBMcH** · 05-15-2008, 11:53 AM

Thanks for taking the time to look at my problem!

Here's an example of what the chart looks like before I remove "15a" from the source data. The value axis is set at a min of zero. In "picture1" the labels that you see along the axis are the labels that I want displayed on the column. I'm not sure what needs a negative value.

**DBMcH** · 05-15-2008, 11:56 AM

edit: forgot the picture

**Andy Pope** · 05-15-2008, 01:55 PM

If you clear the values highlighted the data label TWO still appears.

Replace the value with -10 and the data label should go.

If not can you post a small example workbook, rather than a picture.

**DBMcH** · 05-15-2008, 02:09 PM

Here's what my source Data looks like.

**Andy Pope** · 05-15-2008, 02:31 PM

You will need to set all those empty cells to -10000. This will push all unused labels off the chart.

You still have a couple of labels that are too long for the section of column chart they report to. So for example category 10 and 20 have the label over hanging.

See attached