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.

[former_member183425]

Hi Ayush,

If you want to show your legend in the Graph always, you go to Behavior in the chart properities (Go to Ignore Blank Cells, then Uncheck the selection buttons In series, In values)

If you don't want want to show legend in the graph, you check them, if you check tem chart will get fit into the space you have provided, else chart looks not good.

Regards,

G.S.Ramanjaneyulu.

[arijit_das]

In behavior tab, deselect ignore blank at the end of range (series) checkbox.

[Former Member]

Hi Ayush,

Could you please attach the screenshots for this.