View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Number and % on same chart

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!