Change axis values
 

Excel 2002. Spreadsheet chart plots a cycloid, with x=r(t-SIN(t)) and
y=r(1-COS(t)). The chart produced is correct.

However, I would like the x-axis to display the values of angles (either
degrees or radians) rather than the values calculated by x=r(t-SIN(t)).

Ideas??

TIA

Paddy

Change axis values
 

I'm not sure the request makes sense, but here is what I would do. I would
keep the same XY plot you currently have, hide the X axis (set everything on
the Format Axis/Patterns tab to none), and generate a series that has points
where you want ticks and labels, and use this as your X axis. Here are a few
examples of such custom scaled axes:

http://peltiertech.com/Excel/Charts/...lityChart.html
http://peltiertech.com/Excel/Charts/RecipAxisChart.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Paddy" wrote in message
...
Excel 2002. Spreadsheet chart plots a cycloid, with x=r(t-SIN(t)) and
y=r(1-COS(t)). The chart produced is correct.

However, I would like the x-axis to display the values of angles (either
degrees or radians) rather than the values calculated by x=r(t-SIN(t)).

Ideas??

TIA

Paddy

Change axis values
 

Jon Peltier wrote:
I'm not sure the request makes sense, but here is what I would do. I
would keep the same XY plot you currently have, hide the X axis (set
everything on the Format Axis/Patterns tab to none), and generate a
series that has points where you want ticks and labels, and use this
as your X axis. Here are a few examples of such custom scaled axes:

http://peltiertech.com/Excel/Charts/...lityChart.html
http://peltiertech.com/Excel/Charts/RecipAxisChart.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com

Thanks, Jon.

May be exactly what I need.

Paddy