Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 07, 04:40 PM posted to microsoft.public.excel.charting
al al is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 363
Default Changing values of x-axis to include greek letters

I'm trying to graph the function sin(x) in radians and I want my x-axis to
list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to
do it (short of copying the graph into a paint file, using Microsoft Equation
3.0 to create the equations and replace each value with what I want.

  #2   Report Post  
Old November 7th 07, 07:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 235
Default Changing values of x-axis to include greek letters

Excel has a built-in function called "PI". As an example for creating your
X-axis, try entering "=PI()" into cell A1.

In cell A3 enter "=A1/2".
In cell A4 enter "=A1".
In cell A5 enter "=3*A1"

And so on. The values in cells A3, A4, A5, etc. can now be used as your X
axis.

--
John Mansfield
http://cellmatrix.net





"Al" wrote:

I'm trying to graph the function sin(x) in radians and I want my x-axis to
list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to
do it (short of copying the graph into a paint file, using Microsoft Equation
3.0 to create the equations and replace each value with what I want.

  #3   Report Post  
Old November 7th 07, 07:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 61
Default Changing values of x-axis to include greek letters

Hi,

Try the following method.

Let’s imagine that the angles (in radians) are in Column A.
Convert the angles as multiples of pi in Column B; e.g., the formula for B1
will be =DEGREES(A1)/180
Have the sine values calculated in Column C; e.g., C1 = SIN(A1).
Make a XY-plot of Column C vs Column B. The x-axis would show the angles in
units of pi.
Now, right-click on the x-axis, “Format Axis” -- “Number” -- “Custom”
Under the Format Code, enter General “ p” click “Add” and “Close”
Right-click again on the x-axis -- “Font” and change the font to Symbol.

Regards,
B. R. Ramachandran



"Al" wrote:

I'm trying to graph the function sin(x) in radians and I want my x-axis to
list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to
do it (short of copying the graph into a paint file, using Microsoft Equation
3.0 to create the equations and replace each value with what I want.

  #4   Report Post  
Old November 7th 07, 09:14 PM posted to microsoft.public.excel.charting
al al is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 363
Default Changing values of x-axis to include greek letters

Will that show, on the x-axis the value "pi/2" (with the Greek letter) or
1.5708?

"John Mansfield" wrote:

Excel has a built-in function called "PI". As an example for creating your
X-axis, try entering "=PI()" into cell A1.

In cell A3 enter "=A1/2".
In cell A4 enter "=A1".
In cell A5 enter "=3*A1"

And so on. The values in cells A3, A4, A5, etc. can now be used as your X
axis.

--
John Mansfield
http://cellmatrix.net





"Al" wrote:

I'm trying to graph the function sin(x) in radians and I want my x-axis to
list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to
do it (short of copying the graph into a paint file, using Microsoft Equation
3.0 to create the equations and replace each value with what I want.

  #5   Report Post  
Old November 7th 07, 10:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 560
Default Changing values of x-axis to include greek letters

On Wed, 7 Nov 2007, in microsoft.public.excel.charting,
Al said:

Will that show, on the x-axis the value "pi/2" (with the Greek letter) or
1.5708?


Only the numbers. If you want special text, you need to create a
completely artificial X-axis labelling series, by typing the following
cells:

X-labels
1.570796327 0 p/2
3.141592654 0 p
4.712388980 0 3p/2
6.283185307 0 2p

Where the font in the third column is formatted in the "Symbol" font, as
B.R. says. Now select the first two columns and Paste Special them to
the chart as a scatter series (I assume the chart is a scatter chart),
then use one of the labelling add-ins:

Rob Bovey's Chart Labeler
http://www.appspro.com/Utilities/ChartLabeler.htm

John Walkenbach's Chart Tools
http://j-walk.com/ss/excel/files/charttools.htm

to give that series a set of data labels based on the third column. Then
format the series to be invisible so only the labels show.
Alternatively, for just a few labels, you can put them in manually,
without installing either the of the add-ins (but they can be very
useful if you're doing a lot of advanced Excel charting)

For more tips on making custom axis labels (one of the tougher custom
Excel techniques, but one of the most powerful), check out the tutorials
by Jon Peltier
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

and Tushar Mehta
http://www.tushar-mehta.com/excel/ne...ble_log_scale/

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.


  #6   Report Post  
Old November 8th 07, 12:27 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 61
Default Changing values of x-axis to include greek letters

Hi,

Format the x-axis as I have described in my earlier reponse, as follows.

Right-click on the x-axis, “Format Axis” -- “Number” -- “Custom”
Under the Format Code enter General “ p”
click “Add” and “Close”
Right-click again on the x-axis -- “Font” and change the font to Symbol

It will label the x-axis not as pi/2, pi, 3pi/2, etc, but as 0.5 pi, 1.0 pi,
1.5 pi, etc.

Regards,
B. R. Ramachandran


"Al" wrote:

Will that show, on the x-axis the value "pi/2" (with the Greek letter) or
1.5708?

"John Mansfield" wrote:

Excel has a built-in function called "PI". As an example for creating your
X-axis, try entering "=PI()" into cell A1.

In cell A3 enter "=A1/2".
In cell A4 enter "=A1".
In cell A5 enter "=3*A1"

And so on. The values in cells A3, A4, A5, etc. can now be used as your X
axis.

--
John Mansfield
http://cellmatrix.net





"Al" wrote:

I'm trying to graph the function sin(x) in radians and I want my x-axis to
list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to
do it (short of copying the graph into a paint file, using Microsoft Equation
3.0 to create the equations and replace each value with what I want.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts: How can I get a date axis to include hours and minutes John McCombe Charts and Charting in Excel 2 September 25th 07 06:18 PM
Radar Chart - How to include X axis gridline Michelle Charts and Charting in Excel 1 December 7th 05 09:30 AM
How do I set my X axis to include equal increments of a day? Dianne Charts and Charting in Excel 2 October 9th 05 11:31 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Can auto number (or OFFSET) include letters? Colleen B Excel Worksheet Functions 3 February 21st 05 09:17 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017