R
rmandore
I'm trying to order categories along the x axis in pivot chart view. The
categories are a mix of numbers and letters (CS, 0, N, 2, 4, 6, 8) -- this is
the "Week" field in the database and is in a Text format. There is also a
date corresponding to each category for each "Specimen" in the database.
This is the "Date" field and is in a Date/Time format.
When I graph the "Week" along the x axis (in a Line chart), I get my
categories CS, 0, N, 2, ... but they are out of order (e.g. 6, 8, CS, 0, N,
2, 4). Obviously this doesn't let me see the progession over time. I've
tried sorting by "Specimen" and then "Date" in the design view and that seems
to change the category order but not to the correct one. I don't want to
just plot the "Date" (although this puts them in chronological order) because
I want to see the categories. Any ideas on how to chronologize the "Week"
plot as it's linked to the "Date"?
categories are a mix of numbers and letters (CS, 0, N, 2, 4, 6, 8) -- this is
the "Week" field in the database and is in a Text format. There is also a
date corresponding to each category for each "Specimen" in the database.
This is the "Date" field and is in a Date/Time format.
When I graph the "Week" along the x axis (in a Line chart), I get my
categories CS, 0, N, 2, ... but they are out of order (e.g. 6, 8, CS, 0, N,
2, 4). Obviously this doesn't let me see the progession over time. I've
tried sorting by "Specimen" and then "Date" in the design view and that seems
to change the category order but not to the correct one. I don't want to
just plot the "Date" (although this puts them in chronological order) because
I want to see the categories. Any ideas on how to chronologize the "Week"
plot as it's linked to the "Date"?