Data Points within a stacked column chart

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

I'm having problems with a stacked column chart. I have 155 Data Points that are spread out over 48 columns. When I remove a column from the source data sheet all of the text associated with the data points after the removed column is placed at the bottom of the chart along the category axis. Is it possible to edit the source data without having the data points/text moved?

**Andy Pope** · 05-15-2008, 11:08 AM

Can you post a small example that demonstates the problem?

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

Here's an example.

**Andy Pope** · 05-15-2008, 11:33 AM

I see, even though the data point is zero the data label, showing category, is displayed.

Other than code you could try this.

Fix the Value axis to have a minimum of zero.
The instead of empty or zero values for those that are not to be displayed use a large negative value. Data points outside the plotarea do not display their data labels, usually.

**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.