excelexcel-charts

How to centrally align the labels on Value Axis with tick marks


I am making bar chart in Excel but struggling to keep my labels centrally aligned to tick marks on the Value Axis.

enter image description here

Is there any property which can be used to achieve this alignment in Excel.

Thanks


Solution

  • So did not change the color of the tick marks but they are central, showing the axis settings as well:

    enter image description here

    So, produced a bar chart as asked:

    enter image description here