Microsoft KB Archive/29267

“Floating” Bars

PSS ID Number: Q29267 Article last modified on 06-12-1996

1.x

MS-DOS

= SUMMARY =

The following selections will create a “floating” bar chart if you have a normal bar chart:


 * 1) Change the Y-Axis to Logarithmic.
 * 2) Change the format to Stacked Bar the bars will be “floating”.

= MORE INFORMATION =

To create a “floating” bar chart, make the following selections:


 * 1) 1st Y-Series = 1,-2,3,4.
 * 2) 2nd Y-Series = 2,-3,4,5.
 * 3) 3rd Y-Series = 3,4,5,6.
 * 4) Options:Two Y-Axes -> 1st Series= Left, 2nd = left, 3rd = right.
 * 5) Format for 100% Bar.
 * 6) Options:Right Y-Axis (.)Normal [X] logarithmic.
 * 7) Options:Two Y-Axes - 1st Series= left, 2nd = right, 3rd = right.

After these selections, do the following:


 * 1) View Chart.
 * 2) Format for Stacked Bar.
 * 3) View Chart. Some of the bars will be “floating”.

The following selections will create a “floating” bar chart, if you have two Y-series assigned to left and right Y-axes:


 * 1) Change the Y-axis scale of one to a negative number.
 * 2) Change to stacked bar and bars will be “floating”.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.