Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can time be used as both the x and y variables in scatter plots?
Can time be used as both the x variable and the y variable when
creating a scatter plot? I want to determine the correlation between the time a company TV commercial is aired versus the time of day that we receive phone calls. My objective is to determine which commercials generate the most calls (we run several different spots per day). I assume I will see clusters of calls around specific commercials. I am entering the times in this format: "10:30", "1:15" etc. Thanks. -J |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can time be used as both the x and y variables in scatter plots?
See your other post on this subject.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... Can time be used as both the x variable and the y variable when creating a scatter plot? I want to determine the correlation between the time a company TV commercial is aired versus the time of day that we receive phone calls. My objective is to determine which commercials generate the most calls (we run several different spots per day). I assume I will see clusters of calls around specific commercials. I am entering the times in this format: "10:30", "1:15" etc. Thanks. -J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheets | Excel Worksheet Functions | |||
Formula for a time card | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
xy scatter graph with a scrolling time element | Charts and Charting in Excel |