Add Data to Axis

[D Willett]

Hi guys.

Working on a chart, I would like to add additional information to the horizontal axis ( ref image below ), Is this possible?

[Rudi]

You could concatenate the values in the two columns into a helper column, and use that as the labels for the X-Axis.

Oh, and by the way....
If you do use the formula option, you can concatenate with the CHAR(10) function, so that your labels show below each other instead of on one line.
(See image)

Spoiler

Image 026.png

[HansV]

Place the extra info in the column to the left of the column with the x-values (the numbers), inserting a new column if necessary.
Click anywhere in the chart.
On the Design tab of the ribbon, click Select Data.
Under Horizontal (Category) Axis Labels, click Edit.
Specify the two-column range with the extra values and the numbers as Axis label range.
Click OK, then click Close.

S237.png

[D Willett]

Got It....
I can make a replica column of the JobID (numbers) and add other columns if necessary.
( As with all projects, they grow legs - this one is in Centipede mode !! )

Cheers Guys