Un-rounding fractions...?

Hi all

I've come across something i excel that I can't seem to work around... I'm currently programming a dashboard for quality control (a P-chart), that I need to display the weekly quality as fractions in stead of percentages. That because, I want people to be able to see the sample size. If 30 specimens have been controlled and 3 were bad, I need excel to return the value 3/30. Excel automatically rounds this fraction to 1/10. How can I get around this?


Below, the chart (the circled value SHOULD be 9/30 and not 3/10)

---DASH___.jpg

If you format the data as fractions, doesn't that show as fractions in the chart?

It does, as is visible from the attached picture, the problem is the rounding.

If 10 out of 30 possibilities are defects, I want the chart to NOT round the fraction to 1/3 - I need it to appear like this: 10/30, so that the sample size is visible to the reader.

I think you need to use VBA to change the labels. Something like this:

Please Login or Register  to view this content.

Note that you will likely need to change a few things:
"Chart 1" to the name of your chart
SeriesCollection(1) to the series that you want to label. (An easy way to find this is to record a macro and move one of the data labels. then undo the move).
The 'Range("D"&lcv)....' assumes the numerators and denominators are in their own column (D and E, respectively) and start in row 1

Pauley