Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
i want to create line chart
Hi aniradhaaa
change type to line chart and all done.
Hi,
Attached a sample file using the line charts and On/ off status as dimension.
Hope its help for u.
Iyyappan.