Negative values in bar chart overlap axis labels.

Bonny · Aug 16, 2006

I tried offsetting the labels, but the max is 1000 and that wasn't enough

Andy Pope · Aug 17, 2006

Hi,

You need to set the Tick Mark Labels to low. See here for full instructions.
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

Changing the data label position below the chart axis.	2	Jun 10, 2009
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend	0	Aug 8, 2013
Data labels along below x axis when y axis has negative values	1	Jul 3, 2008
Text-wrapping horizontal axis labels	4	Mar 29, 2010
Pivot Chart with 2 horizontal axis field (categories)	1	Sep 18, 2009
Adding a line to a population bar chart	0	Jul 17, 2012
Excel 2003 - Chart Data Label positions	1	Jun 8, 2012
2007 move axis label & add zero line	1	Apr 10, 2009

Ask a Question