Results 1 to 11 of 11
Thread: 2sided bar graph? (Office 2003)

20070324, 20:58 #1
 Join Date
 Mar 2001
 Posts
 114
 Thanks
 0
 Thanked 0 Times in 0 Posts
2sided bar graph? (Office 2003)
This is another chart that I made years ago, but now can't remember how to do it. I want a horizontal graph with the 0 point in the middle. Then one set of data bars goes to the right, while another set of data bars goes to the left. For instance, the bars going to the right could indicate Average Yearly Earnings, the matching bars going to the left would be for Years of Educationthe point being to show that lower levels of education correspond to lower yearly earnings.
There are a couple of Custom Types charts with 2 axes, but ithey aren't quite what I'm looking for.

20070324, 21:06 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
Please provide more detail. What would be the vertical axis? Perhaps you can give an example of the data you want to chart.

20070324, 21:17 #3
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
You could specify that the second series uses the secondary value axis, then specify that this axis displays its values in reverse order. You'll have to fiddle with the minimum and maximum scales for the primary and secundary value axes.

20070326, 13:31 #4
 Join Date
 Mar 2001
 Posts
 114
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: 2sided bar graph? (Office 2003)
I'm still not finding what I need, but it's not all that important, anyway. I looked back through the last 12 years of my powerpoint files and didn't find an example of it, so maybe I'm having faulty memory about doing this in powerpoint. I know that I first did it using Harvard Graphics, but I switched to powerpoint long ago, and it seems to me that I had recreated it in powerpoint, but maybe not. Thanks for your help

20070326, 13:39 #5
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
Is the attached what you had in mind?

20070326, 13:52 #6
 Join Date
 Mar 2001
 Posts
 114
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: 2sided bar graph? (Office 2003)
yes, thanks! I don't remember having the negative values in the axis, but I haven't checked it out enough yet to see how to change it. I also see now where to set the secondary axisI wasn't finding that before. Thanks again. (I hope this won't be too complicated for my students to understand!!)

20070326, 13:56 #7
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
You can set a custom format <code>General;</code> for both value axes. The second section of this format is blank, meaning that negative values will be hidden. See attached version.

20070402, 16:23 #8
 Join Date
 Mar 2001
 Posts
 114
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: 2sided bar graph? (Office 2003)
I still haven't found the time to look over this in much detail, so I'm still having some problems. When you first set up the chart, which chart type should I select?

20070402, 17:47 #9
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
It's (not surprisingly) a bar chart, but the second series has been plotted on the secondary Y axis, and the secondary axis has been formatted to plot the values in reverse order, and the minimum and maximum scale have been set explicitly.

20070402, 18:59 #10
 Join Date
 Mar 2001
 Posts
 114
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: 2sided bar graph? (Office 2003)
I didn't see your reply until after my 'chart class' was over for the day. I had them load your original example in and then told them to see if they could replicate it from scratch in PowerPoint. Wth everyone working on it, we've pretty much got it figured out to get it exactly the way I want it. Thanks for your help!!

20070402, 19:12 #11
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 31 Times in 31 Posts
Re: 2sided bar graph? (Office 2003)
Good for you! I actually designed the chart in Excel and pasted it into PowerPoint. I almost always do it that way because I find it much easier to manipulate a chart and its data in Excel.