How to adjust patterns (thickness) in an excel bar chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-2876652%22%20slang%3D%22en-US%22%3EHow%20to%20adjust%20patterns%20(thickness)%20in%20an%20excel%20bar%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20using%20Excel%20to%20plot%20a%20bar%20chart%20that%20has%20different%20patterns%20for%20each%20bar%20in%20both%20color%20and%20shape.%20For%20applying%20different%20shapes%2C%20I%20am%20using%20different%20patterns%20for%20each%20bar.%20But%2C%20patterns%20are%20so%20dense%20and%20the%20pattern%20lines%20are%20covering%20each%20other%20such%20that%20the%20shape%20of%20the%20bars%20look%20the%20same%20and%20filled%20by%20a%20solid%20color.%20I%20used%20to%20use%20Rstudio%20and%20it%20gave%20nicely%20thick%20and%20well-spaced%20patterns%20for%20a%20bar.%20I%20see%20Matlab%20also%20can%20do%20so.%20Is%20there%20any%20way%20I%20can%20get%20a%20less%20dense%20pattern%20for%20bars%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E(Patterns%20density%20in%20)%20Excel%20bar%20chart%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319430iC80802DDA677D7D5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22excel.jpg%22%20alt%3D%22excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E(Patterns%20density%20in%20)%20Rstudio%20bar%20chart%3A%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rstudio.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319431i029A2D1564A90E4A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rstudio.jpg%22%20alt%3D%22rstudio.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2876652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876743%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20adjust%20patterns%20(thickness)%20in%20an%20excel%20bar%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1193793%22%20target%3D%22_blank%22%3E%40Aslanpoursadegh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20choose%20patterns%20with%20different%20density%20from%20predefined%20set%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20282px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319438i8211600908E9A83E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using Excel to plot a bar chart that has different patterns for each bar in both color and shape. For applying different shapes, I am using different patterns for each bar. But, patterns are so dense and the pattern lines are covering each other such that the shape of the bars look the same and filled by a solid color. I used to use Rstudio and it gave nicely thick and well-spaced patterns for a bar. I see Matlab also can do so. Is there any way I can get a less dense pattern for bars?

(Patterns density in ) Excel bar chart:

excel.jpg

 

(Patterns density in ) Rstudio bar chart:

rstudio.jpg

3 Replies

@Aslanpoursadegh 

You may choose patterns with different density from predefined set

image.png

@Sergei Baklan Thank you for your reply. I did so, but still, it is too dense compared to that of Rstudio and Matlab. I for example used the pattern in the last column of the third row, but the same pattern in other software gives much less dense lines. Can we adjust this density in Excel?

@Aslanpoursadegh 

Perhaps with VBA programming, but that's not my territory, not sure.