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?
You can do that using pivot table with almost time dimension, then you can see the variation via time.
I hope to help you.
i want to create line chart
change type to line chart and all done.
Attached a sample file using the line charts and On/ off status as dimension.
Hope its help for u.
Retrieving data ...