#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Graphs dcinc74 Excel Discussion (Misc queries) 1 July 25th 06 02:33 PM
EXCEL Scatter Graphs dcinc74 Charts and Charting in Excel 2 July 25th 06 01:40 PM
Pasting Graphs - making me crazy! BankC Excel Discussion (Misc queries) 1 April 25th 06 06:12 PM
HYPERLINK GRAPHS Aurora Charts and Charting in Excel 0 April 10th 06 04:46 PM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"