Module 2: Using Word, Excel, and PowerPoint for Academic Coursework

Tips for Formatting Chart Elements Using Excel

Chart Borders

To format the chart borders, follow these steps:

• Select the Chart
• Right click
• Choose "Format Chart Area"
• Choose the "Patterns" tab
• In "border" select "none" or another option

Chart Background Colors

To format the chart background colors, follow these steps:

• Select the Chart
• Right click
• Choose "Format Chart Area"
• Choose the "Patterns" tab
• In "area" select a color or fill effect

Chart Bar or Column Colors

To format the chart bar/column colors, follow these steps:

• Select the bar/column that you want to change
• Right click
• Choose "Format Data Series"
• Choose the "Patterns" tab
• In "area" select a color or fill effect

Chart Bar or Column Width

To format the chart bar/column width, follow these steps:

• Select the Chart
• Right click
• Choose "Format Data Series"
• Choose the "Options" tab
• Increase the number in "gap width".

Chart Gridlines

To format the chart gridlines, follow these steps:

• Select the Chart
• Right click
• Choose "Chart Options"
• Choose the "Gridlines" tab
• Choose the gridlines option you want.