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