Excel

The UK's most regular instructor-led training courses.
Training information: vba excel course london · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

Excel

Jonathan has attended:
Excel Introduction course

by - delegate Jonathan [1 post] (2008 May 12 Mon, 16:58) Reply

When a chart is created can one change the axis or are they determined by the horizontal and vertical rows/columns of the spreadsheet. What is the default, i.e. the vertical/left hand column creates which axis? Many thanks.

Jonathan

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 18:14) Reply

Hi Jonathan

Click on the chart and then go to the dropdown on the chart toolbar. Choose the Axis you want to change and edit it!

You could also point directly at the axis, right click and choose the FORMAT AXIS option from the shortcut menu.

· Compare Different MS Excel Training Methods
· How Excel Training Can Improve Your Company's Sales Process
· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part Three
· How to Create Better Excel Spreadsheets: Part Four

Please browse our web site to find out more about
vba excel course london and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips