How to Create a Bar Graph in Excel without Numbers – 3 Methods

The dataset showcases products that were returned for different reasons and the Refund Status (set to Yes or No).

To create a Bar Graph using this data:

Dataset-How to Make a Bar Graph in Excel without Numbers

 


Method 1 – Applying the COUNTIF Function to create a Bar Graph without Numbers 

Step 1:

  • Enter the following formula in G4.
=COUNTIF(C:C,F4)

In the formula, C:C is the range and F4 is the criteria.

COUNTIF Function-How to Make a Bar Graph in Excel without Numbers

Step 2:

  • Press ENTER and drag the Fill Handle to apply the formula to the other cells.

Fill Handle

Step 3:

  • Select the range, go to the Insert tab > Click Insert Column or Bar Chart (in Charts) > Click a Bar Chart type.

Bar Chart Insertion

A Bar Chart is displayed. Format the Chart.

Bar Chart

Read More: How to Make a Simple Bar Graph in Excel


Method 2 – Combining Functions to Create a Bar Graph without Numbers

Find the Percentage of the Refund Status.

Step 1:

  • Use the formula in G4. Drag down the Fill Handle to see the result in the rest of the cells.
=COUNTIF($D:$D,F4)/(COUNTA($D:$D)-1)

the COUNTIF function returns the Refund Status occurrences and COUNTA the non-numeric entries, except the column header.

COUNTIF and COUNTA Function-How to Make a Bar Graph in Excel without Numbers

Step 2:

  • Follow Step 3 in Method 1 to insert a bar chart.

Bar Chart

Read More: How to Create a Bar Chart in Excel with Multiple Bars


Method 3 – Using a PivotTable to Create a Bar Graph Using Non-numerical Data

Step 1:

  • Select the range and go to Insert > Click PivotTable (in Tables) > Click From Table/Range.

Pivot Table-How to Make a Bar Graph in Excel without Numbers

Step 2:

  • In the PivotTable from table or range dialog box, check New Worksheet in Choose where you want the PivotTable to be placed > Click OK.

Pivot Table window

Step 3:

  • In the PivotTable Fields window, check Refund Reason or Refund in Choose fields to add to report > Place the fields as shown in the below.

Pivot Table Format window

If you check Refund, the field placements are:

Refund-Pivot Table Format window


To display the Count:

Step 1:

  • Click the Arrow Sign beside Values.
  • Click Value Field Settings.

Value Fields Settings

Step 2:

  • Select Summarize Value By > choose Count > Click OK.

Summarize value field by Count


The bar graph is displayed.

Bar graph-Refund Reason

This is the bar graph of the refund status:

Bar Graph-Refund

Read More: How to Make a Grouped Bar Chart in Excel


Download Excel Workbook


Related Articles


<< Go Back to Excel Bar Chart | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo