Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Graphs
Hi all I have a set of data which consists of time or scans there are a total of 28404 of them ranging from 00:00:01 to 21:58:34. What I would like is to plot this within a scatter graph, with time of day ie 00:00:00 to 22:30:00 on the X-axis and the time of scans along the Y axis. I assumed it was just adding another column with the times in however this is not the case please can anyone assist e? cheers |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Graphs
Put your X values (time of day) in a column and the Y values (time of scans)
in the next column to the right. Select the data and make an XY chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Songoku" wrote in message ... Hi all I have a set of data which consists of time or scans there are a total of 28404 of them ranging from 00:00:01 to 21:58:34. What I would like is to plot this within a scatter graph, with time of day ie 00:00:00 to 22:30:00 on the X-axis and the time of scans along the Y axis. I assumed it was just adding another column with the times in however this is not the case please can anyone assist e? cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter Graphs | Excel Discussion (Misc queries) | |||
EXCEL Scatter Graphs | Charts and Charting in Excel | |||
Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
HYPERLINK GRAPHS | Charts and Charting in Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel |