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
|
|||
|
|||
Excel 2000 X axis conundrum
Hi all,
I'm having trouble with some charts I am making in Excel 2000. What I want is to be able to plot 3 repeat X axes one after the other but I cant work out how to do it. My data has 0 to 600 seconds along the X which I would like to repeat a further twice in a row along the x axis (0-600, 0-600, 0-600). When I plot up the data, Excel only displays one 0-600 x axis and plots all my Y values against this single X resulting in a very muddled plot. Can anyone help? Cheers Scott |
#2
|
|||
|
|||
Excel 2000 X axis conundrum
The easiest way to create 3 X axis would be to create three charts
embedded in a worksheet (or chartsheet). Format and align them to get the desired visual effect. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi all, I'm having trouble with some charts I am making in Excel 2000. What I want is to be able to plot 3 repeat X axes one after the other but I cant work out how to do it. My data has 0 to 600 seconds along the X which I would like to repeat a further twice in a row along the x axis (0-600, 0-600, 0-600). When I plot up the data, Excel only displays one 0-600 x axis and plots all my Y values against this single X resulting in a very muddled plot. Can anyone help? Cheers Scott |
Thread Tools | |
Display Modes | |
|
|