How to Graph Ratios in Excel (2 Quick Methods)

For a better understanding of data sometimes we show data in a graph. This is mostly used for financial calculations and office presentations. Excel has some built-in features to calculate and show the graph in the workbook. In this article, I will explain how to graph ratios in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Simple Methods to Graph Ratios in Excel

Today I am going to share with you 2 simple methods to graph ratios in excel. Stay tuned.


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.

Suppose we have a dataset of some Student’s Name, their Height, Weight, and Ratio of height and weight. Now we are going to graph the ratio.

Graph Ratios in Excel

Step 1:

  • Firstly we are going to calculate the decimal value from the dataset.
  • Select a cell to get the decimal value. Here I have selected cell (F5).
  • Apply the formula-
=C5/D5

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • Hit Enter to get the value.
  • Pull the “fill handle” down to get the numbers in all cells.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • Thus we will get our decimal values to make a graph.

Convert Ratios to Decimal Values to Graph Ratios in Excel

Step 2:

  • Now selecting the decimal values from the column go to the “Insert” option from the home ribbon.
  • Click on the “Bar column” icon and select the left one from the “2-D Column”.

  • Here we have successfully made our graph. It’s time to edit the graph. Let’s do it.

  • Select the graph to edit.
  • Now from the filer option choose “Select Data”.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • A new window will appear named “Select Data Source”.
  • From there hit the “Edit” option to edit data.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • A new window will pop up named “Axis Labels”.
  • From the dataset select the range of names and press OK.

Convert Ratios to Decimal Values to Graph Ratios in Excel

  • Thus we will get our desired graph which shows ratios from the dataset.

Read More: How to Calculate Ratio of 3 Numbers in Excel (3 Quick Methods)


2. Alter Constant Ratios to Decimal Values to Graph Ratios

While working with a dataset sometimes you get constant ratios. At that time you might need to calculate the graph in a different way. In this method, I am explaining how you can make a graph with constant ratios.

Here we have a dataset of a shop. In this dataset, we have the Total Number of Sold products and their Ratio. To plot the graph firstly we will calculate the products sold by A & B.

Alter Constant Ratios to Decimal Values to Graph Ratios

Step 1:

  • Choose a cell (D5) to apply the formula.
  • Put the formula in the cell-
=2*B5/5

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Press Enter and then drag down the “fill handle” to get the output.

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Here we have our values which were sold by A.

Now let’s calculate the product sold by B.

Step 2:

  • Select a cell. Here I have selected cell (E5).
  • Apply the formula-
=3*B5/5

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Hit Enter and drag down the “fill handle”.

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Thus we will get the output in the cell (E5:E11) showing products sold by B.

Step 3:

  • Select cells (D4:E11) to plot the graph.
  • Selecting the cells click on the “Insert” option.

Alter Constant Ratios to Decimal Values to Graph Ratios

  • Now select a linear chart from the options.

Graph Ratios in Excel

  • Thus we can graph ratios easily in a linear chart.

Read More: How to Calculate Ratio Between Two Numbers in Excel (5 Ways)


Things to Remember

  • You can alter graph data in vertical and horizontal directions too. Follow the steps. After plotting the graph go to the “Filter” option. From there click “Switch Row/Column” to change the direction to a different axis.

Conclusion

In this article, I have tried to cover the simple and quickest ways to graph ratios in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo