Attach cell values to each label on axis

**chococ** · 10-01-2015, 12:57 PM

Hello,

I am hoping to attach a cell value to the axis labels, along with the colour (red/black). I have many graphs to make so I can't possibly create a text box for each and manually align them under each label. So in the attached workbook, I want "50%" to appear under "A" on the x-axis, "8%" to appear under "B", "-13%" (in red) to appear under "C" and so on. Can anyone help me please??

Thanks a lot in advance!

Percentage in axis.xlsx

**AlphaFrog** · 10-01-2015, 01:43 PM

Here's an easy way to do it without VBA but with a caveat; it surrounds the negative percentages with parenthesis instead of displaying in red font.

Insert a new column B to concatenate the Product with the Percent Change
New column B formula: =A2& " " & CHAR(10) & TEXT(E2,"0%_ ;""(""-0%)")
Change the chart data source to use column B for the X axis instead of column A
=SERIES(Sheet1!$C$1,Sheet1!$B$2:$B$6,Sheet1!$C$2:$C$6,1)

Untitled.png