View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Paddy Paddy is offline
external usenet poster
 
Posts: 8
Default 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