PC & Mobile

How to create Pictograph in Excel

A Pictograph or a Pictogram is a chart that makes use of photos to signify knowledge. A Pictogram chart is represented the identical approach as a bar chart, however as a substitute of utilizing bars, they use photos to show the info. In this tutorial, we are going to clarify how to create a Pictograph chart in Excel.

How to create Pictograph in Excel

Follow the steps beneath to make a Pictograph chart in Excel.

  1. Launch Excel.
  2. Enter knowledge into the spreadsheet or use an present one.
  3. Right-click any of the bars in the chart and choose Format Data Series.
  4. Click the Fill and Line tab.
  5. In the Fill part, click on Picture or texture fill.
  6. In the Picture Source part, click on the Insert button.
  7. An Insert Picture dialog field will open and choose Online Pictures.
  8. Type apple in the search engine.
  9. Choose an apple and click on Insert.
  10. Click Stock and Scale with.
  11. Click the Series Options tab and Change the Gap Width to 0%.
  12. Close pane.

Launch Excel.

Enter knowledge into the or use an present one.

Click the Insert tab, click on the Bar Chart button, and choose the Stacked Bar in the 2-D part.

The bar chart will seem on the spreadsheet.

Now we would like to substitute the bars and enter photos on the bar chart as a substitute.

Right-click any of the bars in the chart and choose Format Data Series from the context menu.

Click the Fill and Line tab.

In the Fill part, click on Picture or texture fill.

In the Picture Source part, click on the Insert button.

An Insert Picture dialog field will open and choose Online Pictures.

Type in the Word apple in the search engine and press enter.

Choose an apple and click on Insert.

You will discover that the photographs in the bar chart are stretch out and solely reveals one apple for every.

To repair this concern click on Stock and Scale with.

Now click on the Series Option tab and Change the Gap Width to 0%.

You will discover that the apple in the chart is completely aligned.

Close the pane.

Now we have now a Pictograph chart.

Where can I create a pictograph?

You would not have to use a complicated program to create a pictograph chart. Pictograph charts may be created utilizing Microsoft Office applications corresponding to Word, PowerPoint, and Excel. These applications are recognized to create charts to showcase knowledge.

What is pictograph used for?

A Pictograph is a chart that showcases photos representing knowledge and is about up like a bar chart. The Pictograph is principally used to illustrate statistical knowledge. The quantity you enter in your desk is the variety of photos you’ll get for every class.

How a pictograph and bar chart are the identical?

A Pictograph chart and a bar chart are related; they each present knowledge in an identical setup. The solely distinction between the 2 is that pictographs use photos to show info, whereas bar charts use numbers to show info.

READ: How to create a Bubble Chart in Excel

What is one benefit of utilizing a pictograph?

Below are some benefits of utilizing pictographs:

  1. It is used to specific giant info.
  2. It is straightforward to learn.
  3. It doesn’t want an additional rationalization.

READ: How to change Layout and Chart Style in Excel

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button