Area

Good when you want to emphasis an amount of change over time. Each line represents a data series.
Displays the trend of values over time or over categories
The area below each line is filled in.


Series Options


 

Plot series on primary axis -
Plot series on secondary axis -


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, Tile picture as texture, Offset x, Offset y, Scale x, Scale y, Alignment, Mirror type, Rotate with shape.
Pattern fill - Pattern, Foreground, Background Automatic - Color
Automatic - Color


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


Effects

Refer to the Page - Chart Formatting > Effects


 


In Excel 2007, the numerical value is not shown in the mouse over ?


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext