Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2006

Tip: Looking for answers? Try searching our database.

XY Scatter Y-Axis Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jsgibbs - 27 Feb 2006 16:53 GMT
I have the following sample of a data set.  The actual data is about 90
rows long.  

Difference between send date and open date, and Open time

0  8:15am
0  9:37am
0  1:30pm
1  10:30am
1  4:30pm
2  7:35am
3  8:45am
3  9:46pm
4  5:45am

When I do an XY Scatter, the Y-axis scale is 12am - 12pm for each da
(i.e. 0,1,2...) So in this example there would be five sets of 12am
12pm, one for 0, one for 1, etc.    How do I make the graph so that th
Y-Axis is simply one set of 12am - 12pm and not 12am - 12pm for each da
, and the X-Axis is the difference between send date and open date (i.e
0,1,2...)?  In other words, I would like to see, on Day 0 the email wa
open at these times (data point for each), on Day 1 the email was ope
at these times...etc.

Thanks so much
Kelly O'Day - 28 Feb 2006 01:09 GMT
I made an XY (Scatter) chart like you described. it worked fine.

I placed the days in Column A and times in column B. I had to reformat your
times so that Excel recognized them. I added a space between last minute
digit and am/pm. Excel showed that it recognized the time by capitalizing.

> I have the following sample of a data set.  The actual data is about 900
> rows long.
[quoted text clipped - 21 lines]
>
> Thanks so much.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.