Welcome toExcel2007.Tips.Net
Helpful Links
Beauty Tips
Money Tips
Organizing Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Formatting a Chart's Axis
Summary: Create a chart in Excel can you can then modify it almost any way you desire. One modification is to adjust the color or pattern applied to an axis. This tip examines the ways you can do this.Most people who create charts with Excel don't know that you can change just about everything that controls how the chart appears. One of the things you can easily change is the pattern used to denote a chart's axis. By default Excel normally uses a solid line for an axis. If you want to change the pattern used by Excel, follow these steps:
- Right-click on the axis whose pattern you want to change. Excel displays a Context menu for the axis.
- Choose Format Axis from the Context menu. (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis dialog box. (Click here to see a related figure.)
- Use the Line Style selection to specify how the axis line should look.
- Use the Line Color selection to select a color for the axis.
- Click on OK.
Related Tips:
Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time! Check out WordTips Archives today!