J
J Laroche
TIP
I've been working extensively with Excel (Windows and Mac) for over ten
years, and only today did I discover "multiple-level category labels" in
charts, and it was by accident. Make a search on the quoted terms in help to
see an example. This functionality might come very handy, and is probably a
surprise to most people, save the professionals.
Briefly, what it does is put many levels X-axis labels. Assuming Y-data is
in column, each level comes from a different column of the X-data source. If
the latter is defined as A112 for example, there will be 4 label levels
with data in the D column being nearer to the axis and data in the A column
the farther (lower). Moreover, if some cells are blank, the first non-blank
cell above is used as a meta-label for the lines below, i.e. it's shown only
once on the axis, centered on the labels above (like a merged cell). See the
picture in help or try for yourself, it's easier to grasp.
The X-axis labels can also be made of discontinuous ranges (or a single
named range made of multiple discontinuous ranges). If each range contains
cells lined up perpendicularly to the Y-data, each cell will appear stacked
vertically at the same tick mark. Each range can contain a different
quantity of cells.
Wow! I can't wait to find a suitable chart to use that.
JL
Mac OS X 10.3.8, Office v.X 10.1.6
I've been working extensively with Excel (Windows and Mac) for over ten
years, and only today did I discover "multiple-level category labels" in
charts, and it was by accident. Make a search on the quoted terms in help to
see an example. This functionality might come very handy, and is probably a
surprise to most people, save the professionals.
Briefly, what it does is put many levels X-axis labels. Assuming Y-data is
in column, each level comes from a different column of the X-data source. If
the latter is defined as A112 for example, there will be 4 label levels
with data in the D column being nearer to the axis and data in the A column
the farther (lower). Moreover, if some cells are blank, the first non-blank
cell above is used as a meta-label for the lines below, i.e. it's shown only
once on the axis, centered on the labels above (like a merged cell). See the
picture in help or try for yourself, it's easier to grasp.
The X-axis labels can also be made of discontinuous ranges (or a single
named range made of multiple discontinuous ranges). If each range contains
cells lined up perpendicularly to the Y-data, each cell will appear stacked
vertically at the same tick mark. Each range can contain a different
quantity of cells.
Wow! I can't wait to find a suitable chart to use that.
JL
Mac OS X 10.3.8, Office v.X 10.1.6