Change axis values

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
 
J

Jon Peltier

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
 
P

Paddy

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

Thanks, Jon.

May be exactly what I need.

Paddy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top