Ticker

6/recent/ticker-posts

MS-Excel (Chart Layout Menu)

CHART LAYOUT MENU IN EXCEL



Format Selection: This tool is used to change the format of selected chart and as you will click on this tool, it will show "Format Chart Area" dialog box with following options.

1. Fill: This option is used to change the background color of selected chart.

2. Border color: This option is used to change the border color of selected chart

3. Border Styles: This option is used to change the border style of selected chart.

4. This option is used to change the shadow settings of selected chart.




Reset to Match style: This option is used to reset all the formats (that you made after the last save) in selected chart.

Chart Titles: This option is used to insert the chart title.

Axis Titles: This option is used to insert Axis chart title

Legend: This option is used to show and hide the chart legend as well as change the legend's default position.





Data Labels: This option is used to show and hide the data labels.

Data Table: This option is used to show and hide the data tables.


Axes: This option is used to show and hide the Axes field.

Gridlines: This option is used to show and hide the horizontal and vertical grid-lines.










Post a Comment

0 Comments