How to change gap width in Excel quickly?
Normally the gap width is automatically calculated based on the date and chart area. Saying the chart area is fixed, the space between two series points may be very narrow if there are many data series, or very wide when fewer data series. Therefore, we need to change the gap width manually. This article is going to guide you how to change the gap width in Excel 2007 and Excel 2010 quickly.
Step 1: Right click the series, and select the Format Data Series item from the context menu, see the following screen shot:
Step 2: In the Format Data Series dialog box, click the Series Option button at left bar.
Then it shows the Gap Width section under the series Option section. See the following screen shot:
You can drag the slider between No Gap and Large Gap to adjust the gap width manually.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!