If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XY Scatter Y-Axis Formatting
I have the following sample of a data set. The actual data is about 900 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 day (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 the Y-Axis is simply one set of 12am - 12pm and not 12am - 12pm for each day , 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 was open at these times (data point for each), on Day 1 the email was open at these times...etc. Thanks so much. -- jsgibbs ------------------------------------------------------------------------ jsgibbs's Profile: http://www.excelforum.com/member.php...o&userid=31966 View this thread: http://www.excelforum.com/showthread...hreadid=516921 |
#2
|
|||
|
|||
XY Scatter Y-Axis Formatting
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. "jsgibbs" wrote in message ... I have the following sample of a data set. The actual data is about 900 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 day (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 the Y-Axis is simply one set of 12am - 12pm and not 12am - 12pm for each day , 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 was open at these times (data point for each), on Day 1 the email was open at these times...etc. Thanks so much. -- jsgibbs ------------------------------------------------------------------------ jsgibbs's Profile: http://www.excelforum.com/member.php...o&userid=31966 View this thread: http://www.excelforum.com/showthread...hreadid=516921 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting In Use (Style and Formatting Task Pane) Slow + Incorrect? | Paul | Formatting Long Documents | 6 | November 8th, 2005 10:36 PM |
Scatter Chart Axis as text in C# Web appl | Pavr1 | Charts and Charting | 1 | March 31st, 2005 05:28 AM |
Formatting X and Y axis' | Joey041 | Charts and Charting | 1 | February 19th, 2005 05:29 AM |
Formatting X Axis Source Data | Nate Carruthers | Charts and Charting | 1 | February 8th, 2005 07:40 PM |
X axis on XY scatter chart | Jasmine | Charts and Charting | 5 | August 12th, 2004 11:22 PM |