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
|
|||
|
|||
What kind of chart?
I have a chart of times vs dates, where an event can occur
many times during a day. for example, my table is written thus: Mon Tue Wed Thu 0700 0730 0700 0800 0730 0800 0830 0900 I would like the chart to appear something like this: 0900 X X 0800 X X X X 0700 X X Mon Tue Wed Thu In the table, I don't want a different line for each time, because they are actually a minute apart, and are copy&pasted from another app. In the chart I would like to have some marker (a dot) at the time where it occurred, and one day's woth of times should stack directly on top of each other. I have had a play with various chart types, but I can't see one that fits my needs. Any help? Cheers! Wendy. |
#2
|
|||
|
|||
What kind of chart?
Wendy:
I think you want a scatter chart. Enter 1,2,3,4,5,6,7, as the days and Format the days using a custom number format: dddd Format | Cells | Number -- custom dddd (or ddd) You may also need a custom format for the times: 0000 The chart wizard should do what you want automatically with your data set up as it is. The days are your X series and the times the y-series. Set the minimum on the X-axis scale to 1 for sunday. Wendy Moncur wrote: I have a chart of times vs dates, where an event can occur many times during a day. for example, my table is written thus: Mon Tue Wed Thu 0700 0730 0700 0800 0730 0800 0830 0900 I would like the chart to appear something like this: 0900 X X 0800 X X X X 0700 X X Mon Tue Wed Thu In the table, I don't want a different line for each time, because they are actually a minute apart, and are copy&pasted from another app. In the chart I would like to have some marker (a dot) at the time where it occurred, and one day's woth of times should stack directly on top of each other. I have had a play with various chart types, but I can't see one that fits my needs. Any help? Cheers! Wendy. -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow |
Thread Tools | |
Display Modes | |
|
|