HomeApplication

How to use pictures as Excel chart columns

Excel provides a variety of chart types including column and bar charts to present your data. However, you don't have to use the preset column and bar layouts. Instead, you can swap them out for chart-themed images or icons to grab people's attention. Here's how to use pictures as Excel chart bars.

Instructions for using images as Excel chart columns

Step 1:

First you create a chart in Excel as usual.

How to use pictures as Excel chart columns Picture 1

Next, you download the image and remove the background of the image . You should use the PNG image you want to replace the column in Excel. Next, use the image background removal feature in Excel to remove the background around the image.

How to use pictures as Excel chart columns Picture 2

 

Step 2:

Click on the first image and press Ctrl+C to copy the image. Next, click on the first chart column twice , the first click will select all columns and the second click will isolate that column. Note that you do not double click. If you do it correctly, you will see the 4 sides of the column selected as shown below.

How to use pictures as Excel chart columns Picture 3

Step 3:

Now you just need to press Ctrl+V to paste the image to replace the column . The result is that you will see the image replace the Excel chart column.

How to use pictures as Excel chart columns Picture 4

We continue to paste the remaining images into the columns and get a new chart as shown below. The image automatically aligns to exactly match the height of each column in the Excel chart.

How to use pictures as Excel chart columns Picture 5

3.5 ★ | 2 Vote

You should read it

May be interested

  • Steps to reset chart in ExcelSteps to reset chart in Excel
    the following article shows you the steps to reset the chart in excel 2013. after creating the chart, if you do not like the selected chart style, you can do the following to change the chart type the simplest and fastest way: step 1: sign
  • How to fix chart position in ExcelHow to fix chart position in Excel
    when you position the chart in excel, users can easily change the size of the column in the worksheet without affecting the position and size of the chart.
  • How to make a thermometer template in ExcelHow to make a thermometer template in Excel
    using a thermometer chart in excel is a good choice for keeping track of financial goals. here are detailed step-by-step instructions on how to make a heat chart in excel.
  • How to delete, add columns in ExcelHow to delete, add columns in Excel
    adding columns in excel or deleting columns is a basic operation and very simple in excel when we process excel tables.
  • 'Moving' chart in Excel'Moving' chart in Excel
    do you see a motion chart in excel? with a simple, self-created viual basic program, you can make your chart move to look lively. suppose, you have a data table with column a containing the variable x (from a4: a19).
  • How to fix columns and headlines in ExcelHow to fix columns and headlines in Excel
    why is it necessary to fix lines in excel. for those who often work with excel files with a large number of records, it is impossible not to use it. the following article details how to fix columns and rows in excel 2013.
  • How to Add Up Columns in ExcelHow to Add Up Columns in Excel
    this wikihow teaches you how to add two or more columns together in an excel document. you can use the sum command on both windows and mac versions of excel to do so. open your excel document. double-click the excel document that you want...
  • How to move rows and columns in ExcelHow to move rows and columns in Excel
    how to move rows and columns in excel. when you edit documents on excel columns and rows it may be during that process that you want to rearrange the order and position of the columns and rows. if you do not know how, you can follow the following method of tipsmake.com.
  • Steps to lock columns in ExcelSteps to lock columns in Excel
    locking columns in excel with a password helps you protect columns, prevent others from changing column content or editing columns, affecting all data of the table.
  • How to create a pie chart in Microsoft ExcelHow to create a pie chart in Microsoft Excel
    pie charts are a great tool for visualizing information. it allows users to see the partial relationship with the entire data.

Application