Two-level axis labels - is it possible to show the Series group label underneath the axis label?

[mezzopiano1423]

Hi folks, I am having trouble with displaying a two-level axis label.

For several locations, I am measuring two of the exact same metrics, but they fit under two categories.

I would love to group the metric Category underneath each Location, so that the user can neatly see how the two categories measure against each other, as opposed to having to refer to the chart legend.

The illustration below shows the current and desired output. Any help would be appreciated, thank you!

 

[mezzopiano1423]

Bump

 

[mezzopiano1423]

Bump

 

[Worf]

Here at work I cannot see the image due to the firewall.

Anyway, see if this page helps: Two-Level Axis Labels (Microsoft Excel)

 

[Worf]

Like this:

 

[mezzopiano1423]

That looks great! Thank you for your help! So the difference between your solution and mine is that my Axis Labels were over the Series, when they should have been over their respective sub-level Axis Labels?

 

[Worf]

Yes, one of the keys for more complex charting is to arrange the source table properly… :wink: