Graphics package, bar chart with several data series, organizing the data bars

[cruiser]

Conducted a survey for a graduate study project, user ranking of
several items. Users were asked to rank the same list as 1st
important, second, etc. Created the bar chart, three series, not a
problem. Professor wishes to see the bars for each series staggered
highest to lowest, left to right, for all three sereis. Unfortunately,
format data series>series order moves the data column IN ALL THREE
series simultaniously. is there any way to create a single histogram
of all three data sereis, maintaining the color key, and order the
data columns for each sereis independently?

 

[jpdphd]

Conducted a survey for a graduate study project, user ranking of
several items. Users were asked to rank the same list as 1st
important, second, etc. Created the bar chart, three series, not a
problem. Professor wishes to see the bars for each series staggered
highest to lowest, left to right, for all three sereis. Unfortunately,
format data series>series order moves the data column IN ALL THREE
series simultaniously. is there any way to create a single histogram
of all three data sereis, maintaining the color key, and order the
data columns for each sereis independently?

I don't really see the value in presenting the data this way (aside
from appeasing your professor). But, if you must...

You could get the data ordered in the way you (or the prof) wants, in
the spread sheet itself. Plot it, initially ignoring the colors. Then,
color each bar separately. To select an individual bar, select the
series and then press the right arrow key. Double click it and select
the color. All very tedious, but if it gets you an A, it might be
worth it!

jpdphd/