Format Multi-level Catagory Axis in Chart

[mymou]

You can change the alignment of axis labels on both horizontal (category) and vertical (value) axes.

But when you have multiple-level category labels in your chart, you can only change the alignment of one level of labels.

How can you change the alignment of them all. Help!

 

[SkipVought]

hi,

Could you be more specific about YOUR specific SOURCE DATA and specifically what you expect to see displayed on your chart category axis?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mymou]

For a column chart type in Excel 2010, I have quaitity as values for the Y axis and for the X axis, I have Month as one category and Priority as a second category.

The Priority label is not the primary category and I am unable to align this vertically.

So the chart is just counting the following data with priority and Month as "Row Lables" and a count of Month as "Values" in a pivot table .

Sample data:

Priority Month
ELECTIVE DAYCASE 1
ELECTIVE DAYCASE 1
ELECTIVE IN-PATIENT 1
ELECTIVE IN-PATIENT 2
ELECTIVE IN-PATIENT 2
ELECTIVE DAYCASE 2
ELECTIVE IN-PATIENT 3
ELECTIVE IN-PATIENT 3
ELECTIVE DAYCASE 3
ELECTIVE DAYCASE 3
ELECTIVE IN-PATIENT 4
ELECTIVE DAYCASE 4
ELECTIVE DAYCASE 4
ELECTIVE IN-PATIENT 5
ELECTIVE IN-PATIENT 5
ELECTIVE IN-PATIENT 5
ELECTIVE IN-PATIENT 6
ELECTIVE IN-PATIENT 6
ELECTIVE DAYCASE 6
ELECTIVE DAYCASE 6

 

[SkipVought]

Why do you have

ELECTIVE DAYCASE 1
ELECTIVE DAYCASE 1

TWICE?

Isn't that part of your issue?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mymou]

No. It needs to get counted twice (connected to different procedures with different dates - not relevant for this problem).

 

[SkipVought]

usually, you SUM the values that are plotted on the VALUE axis to the distinct category values.

Also, since you have your categorys sorted by month, I would format the category axis source data table...
[tt]
Month Priority
1 ELECTIVE DAYCASE
1 ELECTIVE IN-PATIENT
2 ELECTIVE DAYCASE
2 ELECTIVE IN-PATIENT
3 ELECTIVE DAYCASE
3 ELECTIVE IN-PATIENT
4 ELECTIVE DAYCASE
4 ELECTIVE IN-PATIENT
5 ELECTIVE IN-PATIENT
6 ELECTIVE DAYCASE
6 ELECTIVE IN-PATIENT
[/tt]
since that is the implied heirarchy of your sort

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Actually, playing around with your category data example AND some dummy value data, I'd suggest using a PivotTable/Chart.

The Category Axis looks like this (only rotated 90^o)
[tt]
-----------------------
ELECTIVE DAYCASE
1 --------------------
ELECTIVE IN-PATIENT
-----------------------
ELECTIVE DAYCASE
2 --------------------
ELECTIVE IN-PATIENT
-----------------------
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}