ExcelBanter - Negative values in bar chart overlap axis labels.

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Negative values in bar chart overlap axis labels. (https://www.excelbanter.com/charts-charting-excel/105448-negative-values-bar-chart-overlap-axis-labels.html)

Bonny

Negative values in bar chart overlap axis labels.

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

Andy Pope

Negative values in bar chart overlap axis labels.

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 10:48 AM.