Hi. In the attached file i have created a basic floating chart.
C:\fakepath\ChartTest.ods
With all specialist charts such as this one the key is the organisation and manipulation of your data. If the minimum value is less than zero then display the min value. If it is greater than zero then you need a spacer to position it in the right location. To position the maximum in the right location just display the maximum if the min is below zero otherwise you need to calculate the difference between the min and the max.
To create this chart I used three calculated data series. 1. The first series is the spacer for the min value. This needs to be be zero if the low is below zero or the same value as the low. The formula is =MIN(0;LowCell). 2. The second to display the low value. This is the low value if below 0 or it must be zero as the spacer has positioned the bottom of the column for low values above 0. The formula is =MIN(0;LowCell). 3. The third series displays the top of the bar. The High value. This is the High value when the low value iss below zero and the difference between the high and low value when the low is above zero. The formula is = HighCell-MAX(0,LowCell).
Once the series are set up, inset a stacked column chart. Then the rest is formatting. 1. Remove borders for all series. 2. Set the first series Area Fill to None. 3. Give the second and third series the same Area Fill colour. 4. Change the location of the horizontal axis labels. Select Outside Start for Place Labels in the PositionIng tab of the format axis dialog.
Hope this helps.
Chers,
John
I am not completely clear on what is required as the description (stacked columns) does not appear to match the displayed example (columns arranged beside each other). Can you edit it to make this clearer? I have edited the question to make consistent use of "column" and "range" rather than "bar" as a bar chart is a separate type of chart in Calc and the question appears to relate to the column chart type. Thanks.