create stacked column chart with macro excel 2007, windows XP

[Tatiana_k]

I'd like to create stacked column chart like

<br>I've created similar dataset with 4 series with macro. It looks fine but width of all column is the same without regard to their numerical value. Please see the chart below.<br>

<br><br>Vba code:<br>With Graph.Chart<br>.ChartType = xlColumnStacked<br>.ChartWizard Title:=titleofthechart<br>.SetSourceData Source:=Worksheets(2).Range(Cells(2, 1), Cells(EndRow, EndCol - 1)), PlotBy:=xlColumns<br>.SeriesCollection(1).XValues = Range(Cells(2, 5), Cells(EndRow, 5))<br>.SeriesCollection(1).Name = Cells(1, 2)<br>.ChartGroups(1).GapWidth = 0<br>.SeriesCollection(2).Name = Cells(1, 3)<br>.SeriesCollection(3).Name = Cells(1, 4)<br>End With<br><br>Is there any solution for this issue?<br>Thanks in advance,<br>Tatiana

 

[Andrew Poulsom]

Welcome to MrExcel.

To create a chart with variable column widths you would need to use an Area chart. Here's an example:

Variable column width

 

[Tatiana_k]

Awesome, thanks a lot. I'll try it with stacked column chart.