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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cruiser - 16 Oct 2007 19:46 GMT

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?

Reply to this Message

jpdphd - 16 Oct 2007 22:45 GMT

> Conducted a survey for a graduate study project, user ranking of
> several items. Users were asked to rank the same list as 1st
[quoted text clipped - 5 lines]
> 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/

Reply to this Message

Mac Forum / Applications / Excel / October 2007

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