How to use infographics to customize a chart in Microsoft Excel
Did you know that you can use meaningful icons to customize charts in Microsoft Excel, for example icons for demographic data? Just copy a picture (you can find numerous icons online, just watch out for copyright claims), select the series, and paste the icon right on top. Under Format Data Series, Fill and Line, choose Stack and Scale with and set Units/Picture to 100. Under Series Options you can adjust the Gap Width for better visibility of icons and also resize the chart.
0:00 Copy and paste an icon on a chart series (shape fill)
0:17 Check stack and scale with, specify units per picture
0:34 Adjust bar gap width for better visibility
0:45 Remove chart legend and resize the chart
For more contents like this, please subscribe to my channel.
#MsExcel #ExcelTips
Screenshots used with permission from Microsoft.