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. 


Thread Tools  Display Modes 
#1




Changing values of xaxis to include greek letters
I'm trying to graph the function sin(x) in radians and I want my xaxis 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. 
Ads 
#2




Changing values of xaxis to include greek letters
Excel has a builtin function called "PI". As an example for creating your
Xaxis, 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 xaxis 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




Changing values of xaxis 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 XYplot of Column C vs Column B. The xaxis would show the angles in units of pi. Now, rightclick on the xaxis, “Format Axis” > “Number” > “Custom” Under the Format Code, enter General “ p” click “Add” and “Close” Rightclick again on the xaxis > “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 xaxis 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




Changing values of xaxis to include greek letters
Will that show, on the xaxis the value "pi/2" (with the Greek letter) or
1.5708? "John Mansfield" wrote: > Excel has a builtin function called "PI". As an example for creating your > Xaxis, 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 xaxis 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




Changing values of xaxis to include greek letters
On Wed, 7 Nov 2007, in microsoft.public.excel.charting,
Al > said: >Will that show, on the xaxis 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 Xaxis labelling series, by typing the following cells: Xlabels 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 addins: Rob Bovey's Chart Labeler http://www.appspro.com/Utilities/ChartLabeler.htm John Walkenbach's Chart Tools http://jwalk.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 addins (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.tusharmehta.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




Changing values of xaxis to include greek letters
Hi,
Format the xaxis as I have described in my earlier reponse, as follows. Rightclick on the xaxis, “Format Axis” > “Number” > “Custom” Under the Format Code enter General “ p” click “Add” and “Close” Rightclick again on the xaxis > “Font” and change the font to Symbol It will label the xaxis 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 xaxis the value "pi/2" (with the Greek letter) or > 1.5708? > > "John Mansfield" wrote: > > > Excel has a builtin function called "PI". As an example for creating your > > Xaxis, 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 xaxis 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. 
Thread Tools  
Display Modes  


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 