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?
Can you post a small example that demonstates the problem?
Here's an example.
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.
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.
edit: forgot the picture
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.
Here's what my source Data looks like.
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
Ok, now I understand. Thanks for all your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks