What kind of chart?

  • Thread starter Thread starter Wendy Moncur
  • Start date Start date
W

Wendy Moncur

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.
 
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
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.
Click to expand...

--
Gary Klass
(e-mail address removed)
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
 
Back
Top