Chart: formula for data label value?

[Former Member]

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

[Former Member]

Thank you Graham,

Yes, great idea. I was thinking of using overlaying but only by printing text. Never thought of using a second graph.

[former_member260594]

Magnus,

You could use a second chart that outputs the count in a section above the chart that outputs the percentage and underlay that section (section expert > underlay following section) . You can also make the bars, labels, and grid lines transparent for the chart being underlayed.