Showing numerator in graph

G

Guest

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.
 
J

Jim Cone

Try the free Excel add-in "Chart Data Labels" available here...
http://www.realezsites.com/bus/primitivesoftware
(no registration required)

Uses selected cells as the data source for the data labels.
Data labels can also be linked to the cells.
Cell formatting is shown in the data label
--
Jim Cone
San Francisco, USA



"JR-BHS" <[email protected]>
wrote in message
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top