nsaint
08-30-2009, 10:33 AM
I am looking to create a chart using VBA. The chart must be a combo Line/Area chart. I know how to do this with regular charts and have codes many examples, but I am running into a problem with this one.
I have six columns of data. The first two I want to be for the first x-axis and the remaining four for the second x-axis. When I try to do this from the chart wizard, it simply splits the total of six columns into two groups - which is not what I want. How can I control in VBA the grouping I mentioned above?
I have six columns of data. The first two I want to be for the first x-axis and the remaining four for the second x-axis. When I try to do this from the chart wizard, it simply splits the total of six columns into two groups - which is not what I want. How can I control in VBA the grouping I mentioned above?