Himesh -

Turn on the macro recorder while you use this approach to build a
two-axis two-column chart (actually it's a four-column chart):

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

What do you mean you have to identify the 80% point? Do you need a
horizontal line at 80%? Then try this:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Himesh wrote:

I am new to VB programming. I am using VB 6.0 and microsoft excel object
library11.0 . I have to create the Pareto Principle graph in which there are
two x axis columns (one for the values and the other on the right side for
cumulative percentage) and i have to identify the 80% point . Please help.