J
JR-BHS
I have a data table in one sheet with a numerator in one cell, denominator in
another and a cell with a formula calculating a rate based off the numerator
and denominator. I then graph (bar graph) the data showing the rate in
another sheet, however, I want to show the numerator (not the rate) on the
bar.
I know that you can choose to show the value of the data under the data
labels tab but this shows the rate that is used to produce the graph...I am
interested in showing the numerator used to calculate the rate.
another and a cell with a formula calculating a rate based off the numerator
and denominator. I then graph (bar graph) the data showing the rate in
another sheet, however, I want to show the numerator (not the rate) on the
bar.
I know that you can choose to show the value of the data under the data
labels tab but this shows the rate that is used to produce the graph...I am
interested in showing the numerator used to calculate the rate.