Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
How to replace below macro to not using macro:-
sub CR01()
set chart = ActiveDocument.GetSheetObject("CH1")
set p = chart.GetProperties
set NoColumns = ActiveDocument.Variables("vNoOfColumns")
set NoRows = ActiveDocument.Variables("vNoOfRows")
p.ChartProperties.TrellisProperties.Columns= NoColumns.GetContent.String
p.ChartProperties.TrellisProperties.Rows= NoRows.GetContent.String
chart.SetProperties p
end sub
Hi,
Sorry that functionality can not be achieved without macro and Macro's are not supported on Ajax.
Regards,
Kaushik Solanki
Hi,
Paul, why dont you use trellis chart instead of the macro.
If you want functionality where if you click on button then you want chart to convert into trellis, then try using two charts one is hidden and other is visible depending on variable.
Regards,
Kaushik Solanki
Hi Kau
I already using the trills chart. i just want apply this in QS , as QS not support macro.
Still not understand why QS not support button using action.
Paul
Hi,
Your application has section access.
Kindly give username and password of admin to open the application.
Regards,
Kaushik Solanki
Hi Kau, I just want to tell you the macro is for trellis chart. because you asking me to make use of trellis chart. so i not quite understand you.
Hi,
Sorry that functionality can not be achieved without macro and Macro's are not supported on Ajax.
Regards,
Kaushik Solanki
Hi,
You can set Trellis option Rows and Columns here. If you want to set it automatically then you have to use Macro for this.
Regards,
Jagan.