How to Graph Ratios in Excel – 2 Methods

 

Method 1 – Convert Ratios to Decimal Values to Graph Ratios in Excel

To graph a ratio you can convert ratios to decimal values and show them in a graph.

The dataset showcases Students’ Name, their Height, Weight, and Ratio of height and weight.

To graph the ratio:

Graph Ratios in Excel

Step 1:

Calculate the decimal value in the dataset.

  • Select a cell to get the decimal value. Here, F5.
  • Enter the formula
<span style="font-size: 14pt;"><strong>=C5/D5</strong></span>

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • Press Enter to get the value.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • This is the output.

Convert Ratios to Decimal Values to Graph Ratios in Excel

Step 2:

  • Select the decimal values and go to “Insert”.
  • Click “Bar column” and select “2-D Column”.

  • The graph is created.

  • Select the graph to edit it.
  • Choose “Select Data”.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • In “Select Data Source”, select “Edit”.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • In “Axis Labels”, select the range of names and click OK.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • The graph shows the ratios in the dataset.

Read More: How to Calculate Ratio Percentage in Excel


Method 2 – Alter Constant Ratios to Decimal Values to Graph Ratios

The dataset showcases the Total Number of Sold products and their Ratio.

To plot the graph, calculate the products sold by A & B.

Alter Constant Ratios to Decimal Values to Graph Ratios

Step 1:

  • Select D5 and enter the formula.
<span style="font-size: 14pt;"><strong>=2*B5/5</strong></span>

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Alter Constant Ratios to Decimal Values to Graph Ratios

  • The values sold by A are displayed.

Calculate the products sold by B.

Step 2:

  • Select E5 and enter the formula.
<span style="font-size: 14pt;"><strong>=3*B5/5</strong></span>

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Alter Constant Ratios to Decimal Values to Graph Ratios

The output is displayed in E5:E11.

Step 3:

  • Select D4:E11 to plot the graph.
  • Click “Insert”.

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Select a linear chart.

Graph Ratios in Excel

  • The graph with the ratios is displayed in a linear chart.


Things to Remember

You can alter graph data in vertical and horizontal directions: After plotting the graph go to “Filter” and click “Switch Row/Column”.


Download Practice Workbook


Related Articles


<< Go Back to Ratio in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo