On Fri, 31 Aug 2007, in microsoft.public.excel.charting,
Helen said:

I want to track these responses on a chart (I'm thinking a bar style),
reflecting the percentage of each positive response per Series. Is it
possible to do this without having an additional column for the formula?

In theory, yes. You can create a named range that divides X by Y, then
use that named range in the chart formula.

But it's a party trick: an immense amount of work for no practical
benefit. I strongly advise you to just make the required extra columns.
It's less complicated to develop, less effort to maintain, and more easy
to explain to someone else.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.