LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 262
Default Problem building horizontal bar chart paired bars, centered on zer

How do I describe this in words?
I need to create an Excel chart with these characteristics.
There are horizontal bars, centered vertically at zero. One value is
presented to the left, another to the right. They represent paired choices
from a survey. For example, given the option as to whether people might
pay-down debt, vs. purchase a car, about 75% will say they want to pay down
debt, while 25% will say they will purchase a car. So by setting the value
of 75 to a -75, and using horizontal stacked bar chart, I have a bar to the
left of zero showing 75% and a bar to the right showing 25%. It looks great
and shows the comparison needed. The problem is getting the labels correct.
I need the appropriate label on each bar, left of zero and right of zero, and
up and down, for each pair of survey responses.

There should be two options: (1) I could insert a text box on each bar, or,
(2) I should be able to put the labels in a column and have them
automatically. Option 1 is easy, but time-consumng, and option 2 would be
more flexible when I do updates to the chart. I cant figure out how to do
option 2. Any suggestions?

keith

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep chart centered to the page Mary Charts and Charting in Excel 0 October 7th 08 02:05 PM
Bar chart - horizontal bars Unhappy Charts and Charting in Excel 7 April 16th 08 01:13 AM
removing horizontal error bars in excel 2007 chart trueblu Charts and Charting in Excel 3 March 2nd 08 07:42 PM
Excel Chart with Horizontal bars left and right of y-axis (2 datasets) [email protected] Charts and Charting in Excel 1 March 22nd 07 07:23 PM
paired bar chart abj2 Excel Discussion (Misc queries) 2 June 2nd 05 07:58 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"