Multiple-level category labels

I know excel can do it.. I have seen some examples... but
how do I set up my chart to do it. I have one column with a
date and one column with the hour of the day and the third
is the value I want to plot.

My data looks like this.

Date Hour Value
----------------------
9/17/03 20 1694
9/17/03 21 11
9/17/03 22 11
9/17/03 23 10
9/18/03 0 8
9/18/03 1 10
9/18/03 2 12
9/18/03 3 8
9/18/03 4 9
9/18/03 5 8
9/18/03 6 10
9/18/03 7 8
9/18/03 8 8
9/18/03 9 10
9/18/03 10 14
9/18/03 11 12
9/18/03 12 8
9/18/03 13 8
9/18/03 14 6
9/18/03 15 3
9/18/03 16 6
9/18/03 17 6
9/18/03 18 7
9/18/03 19 185
9/18/03 20 746
9/18/03 21 29
9/18/03 22 34
9/18/03 23 22
9/19/03 0 17
9/19/03 1 14
9/19/03 2 14
9/19/03 3 13
9/19/03 4 8
9/19/03 5 11
9/19/03 6 15
9/19/03 7 26
9/19/03 8 28
9/19/03 9 32
9/19/03 10 48
9/19/03 11 43
9/19/03 12 38
9/19/03 13 27
9/19/03 14 35
9/19/03 15 27
9/19/03 16 20
9/19/03 17 17
9/19/03 18 23
9/19/03 19 127
9/19/03 20 450
9/19/03 21 36
9/19/03 22 32
9/19/03 23 32
9/20/03 0 19
9/20/03 1 13
9/20/03 2 6
9/20/03 3 13
9/20/03 4 7
9/20/03 5 5
9/20/03 6 5
9/20/03 7 28
9/20/03 8 28
9/20/03 9 49
9/20/03 10 45
9/20/03 11 42
9/20/03 12 43
9/20/03 13 37
9/20/03 14 38
9/20/03 15 31
9/20/03 16 32
9/20/03 17 27
9/20/03 18 25
9/20/03 19 119
9/20/03 20 364
9/20/03 21 38
9/20/03 22 37
9/20/03 23 33
9/21/03 0 23
9/21/03 1 23
9/21/03 2 12
9/21/03 3 18
9/21/03 4 11
9/21/03 5 4
9/21/03 6 4
9/21/03 7 26
9/21/03 8 20
9/21/03 9 39
9/21/03 10 52
9/21/03 11 53
9/21/03 12 59
9/21/03 13 48
9/21/03 14 55
9/21/03 15 45
9/21/03 16 40
9/21/03 17 32
9/21/03 18 30
9/21/03 19 120
9/21/03 20 310
9/21/03 21 37
9/21/03 22 29
9/21/03 23 30
9/22/03 0 18
9/22/03 1 26
9/22/03 2 17
9/22/03 3 16
9/22/03 4 11
9/22/03 5 6
9/22/03 6 6
9/22/03 7 17
....


You get the point... I want one category label to be the
hour, and one to be the day.

How can i get this set up?

Eric -

Clear the cells that say Date and Hour, but leave the one that says
Value. Select the data, including the top row with two blanks and the
word Value, and make your chart. The two blank cells tell Excel to use
both columns under the blanks for category labels, and the top row for
series names. I don't know if there's a limit on how many columns you
can use for category labels; I wowed a customer today with charts that
used six separate columns, so all of the conditions in our experimental
program were visible right on the chart axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Eric Stephani wrote:
> I know excel can do it.. I have seen some examples... but
> how do I set up my chart to do it. I have one column with a
> date and one column with the hour of the day and the third
> is the value I want to plot.
>
> My data looks like this.
>
> Date Hour Value
> ----------------------
> 9/17/03 20 1694
> 9/17/03 21 11
> 9/17/03 22 11
> 9/17/03 23 10
> 9/18/03 0 8
> 9/18/03 1 10
> 9/18/03 2 12
> 9/18/03 3 8
> 9/18/03 4 9
> 9/18/03 5 8
> 9/18/03 6 10
> 9/18/03 7 8
> 9/18/03 8 8
> 9/18/03 9 10
> 9/18/03 10 14
> 9/18/03 11 12
> 9/18/03 12 8
> 9/18/03 13 8
> 9/18/03 14 6
> 9/18/03 15 3
> 9/18/03 16 6
> 9/18/03 17 6
> 9/18/03 18 7
> 9/18/03 19 185
> 9/18/03 20 746
> 9/18/03 21 29
> 9/18/03 22 34
> 9/18/03 23 22
> 9/19/03 0 17
> 9/19/03 1 14
> 9/19/03 2 14
> 9/19/03 3 13
> 9/19/03 4 8
> 9/19/03 5 11
> 9/19/03 6 15
> 9/19/03 7 26
> 9/19/03 8 28
> 9/19/03 9 32
> 9/19/03 10 48
> 9/19/03 11 43
> 9/19/03 12 38
> 9/19/03 13 27
> 9/19/03 14 35
> 9/19/03 15 27
> 9/19/03 16 20
> 9/19/03 17 17
> 9/19/03 18 23
> 9/19/03 19 127
> 9/19/03 20 450
> 9/19/03 21 36
> 9/19/03 22 32
> 9/19/03 23 32
> 9/20/03 0 19
> 9/20/03 1 13
> 9/20/03 2 6
> 9/20/03 3 13
> 9/20/03 4 7
> 9/20/03 5 5
> 9/20/03 6 5
> 9/20/03 7 28
> 9/20/03 8 28
> 9/20/03 9 49
> 9/20/03 10 45
> 9/20/03 11 42
> 9/20/03 12 43
> 9/20/03 13 37
> 9/20/03 14 38
> 9/20/03 15 31
> 9/20/03 16 32
> 9/20/03 17 27
> 9/20/03 18 25
> 9/20/03 19 119
> 9/20/03 20 364
> 9/20/03 21 38
> 9/20/03 22 37
> 9/20/03 23 33
> 9/21/03 0 23
> 9/21/03 1 23
> 9/21/03 2 12
> 9/21/03 3 18
> 9/21/03 4 11
> 9/21/03 5 4
> 9/21/03 6 4
> 9/21/03 7 26
> 9/21/03 8 20
> 9/21/03 9 39
> 9/21/03 10 52
> 9/21/03 11 53
> 9/21/03 12 59
> 9/21/03 13 48
> 9/21/03 14 55
> 9/21/03 15 45
> 9/21/03 16 40
> 9/21/03 17 32
> 9/21/03 18 30
> 9/21/03 19 120
> 9/21/03 20 310
> 9/21/03 21 37
> 9/21/03 22 29
> 9/21/03 23 30
> 9/22/03 0 18
> 9/22/03 1 26
> 9/22/03 2 17
> 9/22/03 3 16
> 9/22/03 4 11
> 9/22/03 5 6
> 9/22/03 6 6
> 9/22/03 7 17
> ....
>
>
> You get the point... I want one category label to be the
> hour, and one to be the day.
>
> How can i get this set up?
>

[This followup was posted to microsoft.public.excel.charting with an
email copy to Eric Stephani.
Please use the newsgroup for further discussion.]

Maybe, Jon knows something I don't but, with XL2002 I also have to
remove all the duplicate dates (leaving, typically, only the first
unique date). Otherwise the chart x-axis is completely unreadable.

An alternative approach is to leave the table together with its
headings alone and to create a PivotChart with the table as the source.
Set the date and the hour as the row fields and the value as the data
field. XL will do the dirty work for you.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <1a9501c3838b$4e634fd0$a001280a@phx.gbl>, stephe40
@hotmail.com says...
> I know excel can do it.. I have seen some examples... but
> how do I set up my chart to do it. I have one column with a
> date and one column with the hour of the day and the third
> is the value I want to plot.
>
> My data looks like this.
>
> Date Hour Value
> ----------------------
> 9/17/03 20 1694
> 9/17/03 21 11
> 9/17/03 22 11
> 9/17/03 23 10
> 9/18/03 0 8
> 9/18/03 1 10
> 9/18/03 2 12
> 9/18/03 3 8
> 9/18/03 4 9
> 9/18/03 5 8
> 9/18/03 6 10
> 9/18/03 7 8
> 9/18/03 8 8
> 9/18/03 9 10
> 9/18/03 10 14
> 9/18/03 11 12
> 9/18/03 12 8
> 9/18/03 13 8
> 9/18/03 14 6
> 9/18/03 15 3
> 9/18/03 16 6
> 9/18/03 17 6
> 9/18/03 18 7
> 9/18/03 19 185
> 9/18/03 20 746
> 9/18/03 21 29
> 9/18/03 22 34
> 9/18/03 23 22
> 9/19/03 0 17
> 9/19/03 1 14
> 9/19/03 2 14
> 9/19/03 3 13
> 9/19/03 4 8
> 9/19/03 5 11
> 9/19/03 6 15
> 9/19/03 7 26
> 9/19/03 8 28
> 9/19/03 9 32
> 9/19/03 10 48
> 9/19/03 11 43
> 9/19/03 12 38
> 9/19/03 13 27
> 9/19/03 14 35
> 9/19/03 15 27
> 9/19/03 16 20
> 9/19/03 17 17
> 9/19/03 18 23
> 9/19/03 19 127
> 9/19/03 20 450
> 9/19/03 21 36
> 9/19/03 22 32
> 9/19/03 23 32
> 9/20/03 0 19
> 9/20/03 1 13
> 9/20/03 2 6
> 9/20/03 3 13
> 9/20/03 4 7
> 9/20/03 5 5
> 9/20/03 6 5
> 9/20/03 7 28
> 9/20/03 8 28
> 9/20/03 9 49
> 9/20/03 10 45
> 9/20/03 11 42
> 9/20/03 12 43
> 9/20/03 13 37
> 9/20/03 14 38
> 9/20/03 15 31
> 9/20/03 16 32
> 9/20/03 17 27
> 9/20/03 18 25
> 9/20/03 19 119
> 9/20/03 20 364
> 9/20/03 21 38
> 9/20/03 22 37
> 9/20/03 23 33
> 9/21/03 0 23
> 9/21/03 1 23
> 9/21/03 2 12
> 9/21/03 3 18
> 9/21/03 4 11
> 9/21/03 5 4
> 9/21/03 6 4
> 9/21/03 7 26
> 9/21/03 8 20
> 9/21/03 9 39
> 9/21/03 10 52
> 9/21/03 11 53
> 9/21/03 12 59
> 9/21/03 13 48
> 9/21/03 14 55
> 9/21/03 15 45
> 9/21/03 16 40
> 9/21/03 17 32
> 9/21/03 18 30
> 9/21/03 19 120
> 9/21/03 20 310
> 9/21/03 21 37
> 9/21/03 22 29
> 9/21/03 23 30
> 9/22/03 0 18
> 9/22/03 1 26
> 9/22/03 2 17
> 9/22/03 3 16
> 9/22/03 4 11
> 9/22/03 5 6
> 9/22/03 6 6
> 9/22/03 7 17
> ...
>
>
> You get the point... I want one category label to be the
> hour, and one to be the day.
>
> How can i get this set up?
>
>

No, I just didn't test it on a later version than Excel 97 (sorry). I
see the problem Tushar mentions now. You can't skip labels (increase
categories between tick marks beyond 1), or reorient the second level of
label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Tushar Mehta wrote:
> [This followup was posted to microsoft.public.excel.charting with an
> email copy to Eric Stephani.
> Please use the newsgroup for further discussion.]
>
> Maybe, Jon knows something I don't but, with XL2002 I also have to
> remove all the duplicate dates (leaving, typically, only the first
> unique date). Otherwise the chart x-axis is completely unreadable.
>
> An alternative approach is to leave the table together with its
> headings alone and to create a PivotChart with the table as the source.
> Set the date and the hour as the row fields and the value as the data
> field. XL will do the dirty work for you.
>