edit chart axes title

[john_cash]

hi to all,
Is it possible to change the axis title of the attached chart as the attached photo?
I have excel 2007
thank you
john

[john_cash]

I partially solved this
in formulas name management I added

V9 =OFFSET('40R1'!$B$9:$C$9,,,mycount30R2)
V9 =SCARTO('40R1'!$B$9:$C$9;;;mycount30R2)

referred to horizontal axis
a problem
if only one row in the data table only one row is displayed in the titles axis
if more than one rows 2 lines are seen

[Andy Pope]

Slight tweak on named formula

V9: =OFFSET('40R1'!$B$9:$C$9,,,MAX(2,mycount30R2))

Seems like a bug in multi category labels when you only have 1 data point

[john_cash]

Hi andy pope your formula work well.
Thanks you
john