Win7 system adds various types of strip filling methods in Excel2007 histogram

  

The specific method is as follows:

1. Enter [patternui.zip download] in Baidu search bar, download and decompress;

2. Copy the extracted file [PatternUI.xlam] in [C:Program FilesMicrosoft OfficeOffice12ADDINS];

3. Open Excel2007, double-click [PatternUI.xlam] in the ADDINS folder, create a column in Excel. Figure, right click on the histogram, select the menu bar format, find the fill pattern;

4, select all the square columns of the [Series] in the histogram, click [Bar Pattern], select your own applicable pattern as the fill;

Copyright © Windows knowledge All Rights Reserved