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

microsoft excel docs

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


Fill

microsoft excel docs

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

microsoft excel docs

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

microsoft excel docs

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


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