Chart: formula for data label value?
In a bar chart I want to display bars in one unit (ie displaying %) with the Y axis showing that but also want to display a data value label which display something else (the actual count an not in %).
To better explain it with some easy to understand (and easy to explain lol) example:
Let say you want to a report with a bar chart which displays how many faulty items of each product has been reported. This is shown as % of total sales which is the unit used on the y-axis. But on top of each bar I also want to show the number of faulty items (bar showing 5% but label show 1000 items)
Edited by: Magnus Bergh on Sep 29, 2008 5:35 PM