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
|
|||
|
|||
Need 2 rows to display X axis data points for a line graph
X axis is 100 data points, and all must be displayed. They do display, but
are all mushed up. In Corel, you have the option to display the X axis on up to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to manipulate the number of categories between tick marks and tick mark labels, but can't stagger data onto multiple rows. Any ideas or add-ins I could try? Excel 2002. Thanks, Susan |
#2
|
|||
|
|||
Need 2 rows to display X axis data points for a line graph
This web page gives a suggestion for staggering your labels:
http://peltiertech.com/Excel/Charts/Staggered.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "SusanG" wrote in message ... X axis is 100 data points, and all must be displayed. They do display, but are all mushed up. In Corel, you have the option to display the X axis on up to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to manipulate the number of categories between tick marks and tick mark labels, but can't stagger data onto multiple rows. Any ideas or add-ins I could try? Excel 2002. Thanks, Susan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 02:56 PM |
Combined bar and line chart (two Y axis) how to make excel know which data goes where | Bugjam1999 | Charts and Charting | 2 | September 22nd, 2005 11:57 AM |
double window envelope | tpdebronsky | Page Layout | 4 | May 17th, 2005 07:34 AM |
Is it possible to plot this kind of data in a (line) chart w/ preferred axis? How? | pgtr | General Discussion | 4 | September 15th, 2004 02:05 AM |
Line graph along a single axis | conaghan | Charts and Charting | 1 | November 29th, 2003 10:05 PM |