Home |
Search |
Today's Posts |
#1
|
|||
|
|||
numbers above dates on x axis
I have dates on x axis, from Oct 10 1999 through June 19 2000. I would like
to put numbers, starting with 1, above each date. Is it possible to do this as another x axis or is the only option to physically put each number above each date (such as a text box), such as, the number 1 above Oct 10 1999, the number 2 above Oct 11 1999, etc. Thanks for any reply. |
#2
|
|||
|
|||
Nanofish,
Try setting your data up like this - assume the data covers cells A1:C7 and that the title "Data" is in cell C1. The chart will automatically add two X-axis labels - in the case dates on the bottom and numbers on the top. Data 10/1/1999 1 5 10/2/1999 2 7 10/3/1999 3 6 10/4/1999 4 8 10/5/1999 5 7 10/6/1999 6 4 ---- Regards, John Mansfield http://www.pdbook.com "Nanofish" wrote: I have dates on x axis, from Oct 10 1999 through June 19 2000. I would like to put numbers, starting with 1, above each date. Is it possible to do this as another x axis or is the only option to physically put each number above each date (such as a text box), such as, the number 1 above Oct 10 1999, the number 2 above Oct 11 1999, etc. Thanks for any reply. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel |