Hi Luke,

I have created a column which has formulas to calculate percentages. But how
do I enter this data into the existing column chart ( columns show numbers).
I right clicked in the chart area select data Add new series. But its not
showing up. Can you please tell me step wise how can I get the percentage
line in the same chart with columns showing numbers.

Thanks much!

"Luke M" wrote:

You will need to create another series that uses formulas to calculate the
percentage, and then add that to your chart. You can create a combination
chart by selecting the new series, then going to Chart - Chart Type, line.

--
Best Regards,

Luke M
"NM" wrote in message
...
A+B= x

I want to show:
-In one stacked column, I want to show (A+B) and in the same chart in a
line
form I want to show how much percentage is B.

How can I do this?

Thanks!


.