A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How the heck do I plot 'my text' for the X axis? (instead of 1, 2, 3, 4 etc.)



 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2003, 11:32 AM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default How the heck do I plot 'my text' for the X axis? (instead of 1, 2, 3, 4 etc.)

Option 1: Delete the word Week and use the Chart Wizard. For some
unexplicable reason, if XL finds an empty cell in the first row (or
column) it assumes that is the x-axis values, otherwise it assumes all
rows (columns) are y-values. Once the chart is complete put the
contents of the deleted cell back.

Option 2 (and my preferred choice): Leave the data alone. In step 2 of
the wizard, click the Series tab. In the Series field select the first
row (column). Copy the Values field into the 'Category (X) axis
labels' field. Click the Remove button.

--
Regards,

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

In article ,
says...
Hi,

I'm using XL2002 & Win2000Pro.

How can I display the week numbers (as shown) in the x axis, rather than
1, 2, 3, 4 etc. that M$ uses.

Here's my data

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

Here's what I want the axis's to look like

50
40
30
20
10
0
11 12 13 14

How do I do it?

Many thanks!!!

Norm

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

  #2  
Old October 1st, 2003, 05:53 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default How the heck do I plot 'my text' for the X axis? (instead of1, 2, 3, 4 etc.)

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 wrote:
On Wed, 01 Oct 2003 10:32:00 GMT, Tushar Mehta
wrote:


Option 1: Delete the word Week and use the Chart Wizard. For some
unexplicable reason, if XL finds an empty cell in the first row (or
column) it assumes that is the x-axis values, otherwise it assumes all
rows (columns) are y-values. Once the chart is complete put the
contents of the deleted cell back.

Option 2 (and my preferred choice): Leave the data alone. In step 2 of
the wizard, click the Series tab. In the Series field select the first
row (column). Copy the Values field into the 'Category (X) axis
labels' field. Click the Remove button.

--
Regards,

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



WOW!!! Thanks a million Tushar, you made my day. Both solutions are
great, the first if you are creating the chart by selecting the data and
pressing F11, the second as you say, using the Chart Wizard.

Thanks again,

Norm

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


  #3  
Old October 2nd, 2003, 05:59 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default How the heck do I plot 'my text' for the X axis? (instead of1, 2, 3, 4 etc.)

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.