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

Posted: 10-16-2007, 07:46 PM
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 With Quote

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

jpdphd
Guest
Posts: n/a
 
Re: Graphics package, bar chart with several data series, organizing the data bars
Posted: 10-16-2007, 10:45 PM
On Oct 16, 2:46 pm, cruiser <cruise...@comcast.net> wrote:
> 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/

Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't edit chart data lml@officeformac.com Mac Office Power Point 5 08-10-2008 01:57 PM
animation of data series in chart Chilvers Mac Office Power Point 1 05-10-2008 01:38 AM
Sorting data in PowerPoint chart colourtools.com Mac Office Power Point 3 12-10-2007 03:17 PM
Pie chart not showing complete data SBC Mac Office Excel 3 07-20-2007 06:18 PM
Separating percentage and data label in a pie chart? abbyworld@gmail.com Mac Office Excel 0 03-23-2005 09:25 PM