Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoARaymundo
Creator III
Creator III

Macro Set still show total on top

Hi! does anyone know how?

1 Solution

Accepted Solutions
MarcoARaymundo
Creator III
Creator III
Author

sub StillShowTotalOnTop_ON()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = true

chart.SetProperties chartP

Next

end sub

sub StillShowTotalOnTop_OFF()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = false

chart.SetProperties chartP

Next

end sub

View solution in original post

1 Reply
MarcoARaymundo
Creator III
Creator III
Author

sub StillShowTotalOnTop_ON()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = true

chart.SetProperties chartP

Next

end sub

sub StillShowTotalOnTop_OFF()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = false

chart.SetProperties chartP

Next

end sub