Column

H1 - Column Series Options


H2 - Series Options
SS


SS - Series Options
Plot series on primary axis -
Plot series on secondary axis -
Series overlap -
Gap width -



H2 - Fill & Line
SS


SS - Fill
No fill - Makes the series transparent with no fill colour Solid fill - Color, Transparency Gradient fill - Preset gradients, Type, Direction, Angle, Gradient Stops, Color, Position, Transparency, Brightness, Rotate with shape.
Picture or texture fill - Insert picture from file, Insert picture from clipboard, Insert picture from online, Texture, Transparency, Stretch, Stack,


Stack and scale with, Units/picture, Offset left, Offset right, Offset top, Offset bottom, Rotate with shape.
Pattern fill - Pattern, Foreground, Background Automatic - Color Invert if negative - Lets you show a different colour/format for positive and negative values. If you have "Automatic" chosen then a negative value


will be shown with no colour. If you have "solid fill" chosen then you can choose a fill colour for positive and a different fill colour for negative.


SS - Border
No line - No border line is displayed
Solid line - Color, Transparency, Width, Compound type, Dash type, Cap type, Join type. The four Arrow options are never enabled for column charts.
Gradient line - Preset gradients, Type, Direction, Angle, Gradient stops, Color, Position, Transparency, Brightness, Width, Compound type, Dash type,


Cap type, Join type. The four Arrow options are never enabled for column charts.
Automatic - Color, Transparency, Width, Compound type, Dash type, Cap type, Join type. The four Arrow options are never enabled for column charts.


H2 - Effects
SS


SS - Effects
Refer to the Page - Chart Formatting > Effects








Good to display two or more values side by side.
This chart is similar to a bar chart except that the bars are vertical and not horizontal.


Series Options

Plot series on primary axis -
Plot series on secondary axis -
Series overlap -
Gap Width -


Fill & Line - Fill

Invert if negative -
Vary colours by point -


Edit Series

Series Name -
Series Values -


This now includes Cone, Cylinder and Pyramid


Options


Overlap -
Gap width -
Series line -
Vary colours by Point -


3D Options


Gap depth -
Gap Width -
Chart depth -
vary color by point -


Clustered Columns


SS - SS
2 columns of data
(Insert > Column > Clustered Column)
Create 2 series on the same axis
SS
Select Series 2 and move it to the secondary axis
Notice that the two series are now overlapping
SS
You can see this better by changing the series options
Select Series 2, change series overlap to -100%
SS
Select Series 2, change the gap width to 0%
SS


Now insert another series of numbers, next to the existing data
This data will not be displayed and should have the same values as Series 2
SS
Select the chart and drag the range finder to include this additional column
SS
Select Series 1 and change the series overlap to -100%
SS
Select Series 1 and change the gap width to 200%
SS
Select Series 3 and change the fill color to "no fill"
SS
Select the legend and click on the Series 3 text
Press the delete key to remove this entry from the legend
SS


Series 1 is displayed on the left hand (primary) axis
Series 2 is displayed on the right hand (secondary) axis




© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext