Change axis values

  • Thread starter Thread starter Paddy
  • Start date Start date
P

Paddy

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
 
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/ProbabilityChart.html
http://peltiertech.com/Excel/Charts/RecipAxisChart.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
 
Jon said:
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/ProbabilityChart.html
http://peltiertech.com/Excel/Charts/RecipAxisChart.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
Click to expand...

Thanks, Jon.

May be exactly what I need.

Paddy
 
Back
Top