topic Re: Creating a Stacked Line Chart Via Macro in QlikView

Creating a Stacked Line Chart Via Macro

Thu, 11 Sep 2014 19:29:23 GMT

This one took me a little while to track down, so just documenting in case someone else is looking for it (I couldn't find it in any other threads)...

Re: Creating a Stacked Line Chart Via Macro

Thu, 11 Sep 2014 19:32:34 GMT

set cp = chart.GetProperties

set title = cp.ChartProperties.Title

'Stacked line chart

cp.ChartProperties.BarModeStacked = true

cp.ChartProperties.LineChartMode = 3

chart.SetProperties cp

Use LineChartMode = 3 for "Flat" style, or 4 for 3d style.

Re: Creating a Stacked Line Chart Via Macro

rustyfishbones — Wed, 15 Oct 2014 15:44:23 GMT

Hi Graeme,

I have the following code when creating a Scatter Chart to untick the Force 0 box

cp.Expressions.Item(0).Item(0).Data.AxisData.Force0 = false

However this only does the X Axis, how can I also do this for the Y Axis?

Regards

Alan