Search code examples
excelexcel-2013axis-labels

Excel 2013: How to display corresponding text instead of numbers in axis labels?

I've a table of some task's progress, per person and I'd like to plot it on a chart. Y axis - names X axis - progress (NA, start, in progress, completed) and the preferable chart is bars, like that:

sample chart and data

My problems are that I can't substitute the X axis ticks with corresponding words (NA, start...) and I can't fill the bars according to the colors of progress, like in conditional formatting of the data itself. Please help me achieving my goal.

Solution

  • The answers to my questions were answered in two different places:

    1. The technique of conditional formatting of the bars is described on Peltier Tech Blog.

    2. Substitution of X ticks legend is described on Excel Forum in my thread.

    Enjoy!