Chart Column Display

[Former Member]

Hi ALL,

I am using Combination Chart to display my Graph (Displaying as Line Chart)

In which there is 5 Column

IN column 4 there is values in All cell.

but for other column(1,2,3 & 5) there is value or may be it will Blank.

Now if my column 1 2  or 3 is blank my legend is showing Legend for all this column as column 4 is not Blank.

But for column 5 it shows Legend, only if Values is there and if column is blank legend is also Blank.

I want to show column 5 in legend. irrespective of if Value is there or not.

Thanks

[former_member190855 · Accepted solution]

Have you unchecked the Ignore Blank In Values and In Series in the behavior tab?

[Former Member · Accepted solution]

Oh Yes...!

How can I make such a Silly Mistake..!

Buy the Way Thanks.