Complete Stacked Column Chart in Excel 2007

[Burdette]

I want to make a complete Stacked Column chart in Excel 2007. Each stack in the stacked column chart should contain (1) the name of the stack, (2) the number represented by the stack, and (3) the % the number is of the total. Hope someone can help the old man.

 

[ParamRay]

.
.

Try something like this:

Sub AddStackedColumnChart()

    Dim SourceData As Range
    Dim Cht As Shape
    
    'Exit if active sheet is not a worksheet
    If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub
    
    With ActiveSheet
        Set SourceData = .Range("A1:D4") 'Set source data for chart
        Set Cht = .Shapes.AddChart  'Add chart
    End With
    
    'Customize chart
    With Cht.Chart
        .ChartType = xlColumnStacked
        .SetSourceData Source:=SourceData
        .ApplyDataLabels
    End With
    
End Sub

 

[Burdette]

Thanks...I am not very good with coding, but I do use simple stuff and this gives me a chance to try learning soemthing new..

 

[ParamRay]

.
.

No problem. I've only been learning for 6 months or so.

The key is recording your actions and trying to understand/refine the generated code. Also, reading some of the following books will give you a real insight.

Excel VBA Programming For Dummies by John Walkenbach
Excel Power Programming with VBA by John Walkenbach

 

[Burdette]

Thnaks...I know the Statistics for Dummies for statstica is a good book - never thought of Programming for Dummies.
Truth is I have the stacked column chart perfect Except I do not have the % of the stack However I played around with is so much to get where I want it, I am not sure I could do it again -I did not use programming, just funcations within Excel 2007 to get what I have.

Guess I will have to get a book.

BTW - if you have only been doing this for 6 months you have accomplished a great deal- Congradualations.