0

I have a chart which has 3 series- 2 of them needs to be a bar chart and 1 should be a line chart. I tried the various solutions mentioned online to change the chart type of only the series that needs to be changed. Whenever I do that, all series chart types change to the type I change to. For example- if I have series1, series2 and series3 and I change series3 to Line, all the series change to Line chart.

How should I proceed?

Thanks.

user728148
  • 159
  • 1
  • 6
  • 19

1 Answers1

1

You can't have different chart types for a Category or Series - only the Values.

enter image description here

You can probably emulate what you are trying to do by creating 3 different Values and filtering them with an IIF statement.

=IIF(Fields!SeriesType.Value = "Series1", Fields!MyField.Value, NOTHING)
Hannover Fist
  • 10,393
  • 1
  • 18
  • 39