Norm -

There are lots of hidden gems, and either you find them out by accident,
or someone else who found them by accident told you about them.

In a line/column/bar/area chart, right click the chart and pick Source
Data from the pop up menu. Click on the Series tab, select the first
series, select whatever is in the Category (X) Axis Labels box, and with
the mouse select the multiple-row range you want to use. Since all
series use the same categories, you're done.

I made a set of charts at work last week that used five or six rows for
the category labels. This allowed me to put lots of additional
information, test conditions, etc., in the chart under each point. This
made the charts very easy to understand, and the customers went away
happy for a change.

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

Father Guido wrote:
Thanks Jon, for the extra lesson. Isn't Excel wonderful?

Heres a last quick question on this subject. When I fixed up my charts,
I had to redo them from scratch to get the week numbers in the x-axis.

Is there a way to change the x-axsis of an existing chart? Possibly
someone may have need for this option in the future, but wouldn't want
to re-create each chart to achieve this.

Thanks again!

Norm
__________________________________________________ ________
On Wed, 01 Oct 2003 12:53:09 -0400, Jon Peltier
wrote:


I prefer the first option, since I'm too lazy to delete and retype the
header values. Often I put them in the row above the Y column headers,
leaving blanks above the X column header(s). The trick with blanks
works out nicely too if you want multiple row category labels. If you
use two blank cells (say FG had another row, with some other info about
his weeks), if the blank region is two rows high, the first two rows
will be used in the chart:

Data:

A B C D
11 12 13 14
Sales A 43 55 48 32
Sales B 32 36 41 29

Chart:

50 |
40 |
30 |
20 |
10 |
0 |______|______|______|______|
11 12 13 14
A B C D


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



Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good