chart question

i have three columns with numbers and one with a
percentage. I would like to create a graph with stacked
colunns for the numbers and a line for the percentage on
a different axis. is this possible. i know i can do it
with regular columns but i need it with stacked columns.

On Wed, 2 Mar 2005 07:21:07 -0800, "frank" <mrfrank73@aol.com> wrote:

>i have three columns with numbers and one with a
>percentage. I would like to create a graph with stacked
>colunns for the numbers and a line for the percentage on
>a different axis. is this possible. i know i can do it
>with regular columns but i need it with stacked columns.


One way is to include additional rows AND columns for the secondary
axis. For example

Total Subset Subset %
Value 1 8 13
Value 2 86 83
Value 3 6 4
% 1 13%
% 2 83%
% 3 4%

Now you can format the % data series on the secondary axis, then just
delete them out of the legend,

If you need additional help just write back
Bob