Multiple-level category labels

  • Thread starter Thread starter Eric Stephani
  • Start date Start date
E

Eric Stephani

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
 
[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
 
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
 
Back
Top