| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom X-axis Labels
What would the cell formula be to make these x-axis labels? I want only to
change the date in the first cell and have the next five dates be one week later. I presume it is an append (&) but cant figure it out: Cell D4 Cell E4 Cell G4 = €śReported€ť & 9/13/05 =€ťReported€ť & D4+7 €¦. =€ťProjected€ť & F4+7 etc The x-axis column labels would look like this: Reported Reported Reported Projected Projected Projected 13 Sep 05 20 Sep 05 27 Sep 05 4 Oct 05 11 Oct 05 18 Oct 05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
| Linking Axis Labels | Charts and Charting in Excel | |||
Threaded Mode
