Hi guys!
I was hoping someone could help me.
I need to create a
Clustered-Stacked Column Chart with Target Line
From a pivot table
now, it seems easy (I just recorded the macro, here it is):
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlColumnStacked
ActiveChart.SetSourceData Source:=Range("'Capacity Vs Work'!$A$3:$AJ$208")
ActiveChart.Location Where:=xlLocationAsNewSheet
ActiveChart.SeriesCollection(5).Select
ActiveChart.SeriesCollection(5).ChartType = xlLineMarkers
But as you can see I`m choosing the desired series from the report filter which I want to make as a line in my chart
The thing is, when I try to choose different series to display on my chart from the report filter, this definition for series5 goes back to default: stacked columns
Does anyone know how to make a specific series appear always as a line and all the other ones as staked columns even after choosing different series from the report filter to display on the chart?
ActiveChart.SeriesCollection(5).Select
ActiveChart.SeriesCollection(5).ChartType = xlLineMarkers
But as you can see I`m choosing the desired series from the report filter which I want to make as a line in my chart
The thing is, when I try to choose different series to display on my chart from the report filter, this definition for series5 goes back to default: stacked coloumn
Does anyone know how to make a specific series appear always as a line and all the other ones as staked columnes even after choosing different series from the report filter to display on the chart?
I was hoping someone could help me.
I need to create a
Clustered-Stacked Column Chart with Target Line
From a pivot table
now, it seems easy (I just recorded the macro, here it is):
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlColumnStacked
ActiveChart.SetSourceData Source:=Range("'Capacity Vs Work'!$A$3:$AJ$208")
ActiveChart.Location Where:=xlLocationAsNewSheet
ActiveChart.SeriesCollection(5).Select
ActiveChart.SeriesCollection(5).ChartType = xlLineMarkers
But as you can see I`m choosing the desired series from the report filter which I want to make as a line in my chart
The thing is, when I try to choose different series to display on my chart from the report filter, this definition for series5 goes back to default: stacked columns
Does anyone know how to make a specific series appear always as a line and all the other ones as staked columns even after choosing different series from the report filter to display on the chart?
ActiveChart.SeriesCollection(5).Select
ActiveChart.SeriesCollection(5).ChartType = xlLineMarkers
But as you can see I`m choosing the desired series from the report filter which I want to make as a line in my chart
The thing is, when I try to choose different series to display on my chart from the report filter, this definition for series5 goes back to default: stacked coloumn
Does anyone know how to make a specific series appear always as a line and all the other ones as staked columnes even after choosing different series from the report filter to display on the chart?
