microsoft excelmicrosoft-excel-2013
I would like to be able to add my own custom pattern fills for projects I am working on in Excel 2013. For example, I would like to have a brick-like pattern, and a horizontal hash line pattern.
Does anyone know if it is possible to create custom pattern fills to be used in Excel 2013?
I think I have a solution for you: Add a secondary horizontal axis.
The axis setting "Horizontal axis crosses" for the primary vertical axis only affects the primary horizontal axis. The setting for the secondary vertical axis only affects the secondary horizontal axis. It doesn't look like you need a secondary horizontal axis in this case so you can turn it on, set its crossing point to 0, and then hide the labels and tick marks.
Example in Original Condition:
(Chart Tools) Design > Add Chart Element > Axes > Secondary Horizontal
Format Secondary Vertical Axis > Axis Options > Horizontal Axis Crosses > Axis Value = 0
Format Secondary Horizontal Axis > Labels = None, Tick Marks = None, Lines = Black Solid 3.0pt Dashed
Best Answer
After researching this I don't think it is possible I found nothing that allows this and it probably would not be allowed as others opening the file wouldn't have the custom fill patterns.
An idea I had was to replace the cell contents with a image based on a value but the VBA I found was very befuddled and hard to understand I did however find that you can use following to insert images into to the cells based on a value
http://www.extendoffice.com/documents/excel/1858-excel-insert-image-based-on-cell-value.html
I have used other items they produce before and they are reliable.