| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to create a chart with two X value columns
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| Create chart Base on selected Period | Charts and Charting in Excel | |||
| Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel | |||
| Creating a chart with values from two columns | Charts and Charting in Excel | |||
| Chart newbie help, please, How to create | Charts and Charting in Excel | |||
Linear Mode
