Line Chart

[anuradhaa]

I have two catogarical data,

on and off

Then i use if statement and put 1 in the on status if the value is on and 0 if it's off.

I need to display the on/off variation via time.

Please tell me how to do it?

Thanks

[#2]

Hi anuradhaa,

     You can do that using pivot table with almost time dimension, then you can see the variation via time.

I hope to help you.

[anuradhaa]

i want to create line chart

[#4]

Hi aniradhaaa

     change type to line chart and all done.

[v_iyyappan]

Hi,

Attached a sample file using the line charts and On/ off status as dimension.

Hope its help for u.

Iyyappan.