ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter Graphs (https://www.excelbanter.com/charts-charting-excel/116893-scatter-graphs.html)

Songoku

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

Jon Peltier

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





All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com