If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
customize label on X axis
Hello
I'd like to draw a chart with measures done on a non-regularily basis. I can make it with a single curve using a chronological axis in order to have a distance between two points proportionnal to the elapsed time between them. My problem is that Excel displays under the X-axis dates that are separated by an uniform time. I'd like to see only the dates corresponding to the measures. And I'd also like to have a vertical grid corresponding aligned with the points ant not drawn with the same interval. Does someone know a way to do this (if it's possible) ? I must add that I want a graph where the Y-axis scale is automatically defined (just the part concerning the values, the 0 should not be visible). Thanks Olivier Côte |
#2
|
|||
|
|||
customize label on X axis
Hi,
You'll find everything you need on Peltier's excellent=20 homepage; http://www.geocities.com/jonpeltier/Excel/ You'll also need R. Boveys XY indispensable XY chart=20 labeller downloadable from http://www.appspro.com/ good luck -----Original Message----- Hello I'd like to draw a chart with measures done on a non- regularily basis. I can make it with a single curve using a chronological axis=20 in order to have a distance between two points proportionnal to the elapsed=20 time between them. My problem is that Excel displays under the X-axis dates=20 that are separated by an uniform time. I'd like to see only the dates=20 corresponding to the measures. And I'd also like to have a vertical grid=20 corresponding aligned with the points ant not drawn with the same interval. Does someone know a way to do this (if it's possible) ? I must add that I want a graph where the Y-axis scale is=20 automatically defined (just the part concerning the values, the 0=20 should not be visible). Thanks Olivier C=F4te . |
#3
|
|||
|
|||
customize label on X axis
I'd like to draw a chart with measures done on a non-
regularily basis. I can make it with a single curve using a chronological axis in order to have a distance between two points proportionnal to the elapsed time between them. My problem is that Excel displays under the X-axis dates that are separated by an uniform time. I'd like to see only the dates corresponding to the measures. And I'd also like to have a vertical grid corresponding aligned with the points ant not drawn with the same interval. On Thu, 23 Oct 2003 06:24:39 -0700, jacob wrote: You'll find everything you need on Peltier's excellent homepage; http://www.geocities.com/jonpeltier/Excel/ To be a little more specific, try http://www.geocities.com/jonpeltier/...s.html#ArbGrid -- Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|