Posted to microsoft.public.excel.charting
|
|
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
|