JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,531
- Office Version
- 365
- Platform
- Windows
I am generating a chart from this table. I am posting only part of the table for simplicity.
I want the X Axis labels to look like this, which they do very nicely using the data in Column F, which is generated from the data in Columns D & E.
Is there a way I can generate thise X Axis labels in the chart from the data in D & E and get rid of Column F?
Thanks
Book1 | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
5 | Dates | |||||
6 | Start | End | Days | X Axis | ||
7 | 6/10/20 | 8/31/20 | 82 | 8/31/20 (82) | ||
8 | 8/11/20 | 10/27/20 | 77 | 10/27/20 (77) | ||
9 | 10/12/20 | 2/02/21 | 113 | 2/02/21 (113) | ||
10 | 1/20/21 | 2/20/21 | 31 | 2/20/21 (31) | ||
11 | 2/20/21 | 3/07/21 | 15 | 3/07/21 (15) | ||
12 | 3/07/21 | 4/02/21 | 26 | 4/02/21 (26) | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E7:E12 | E7 | =D7-C7 |
F7:F12 | F7 | =TEXT(D7,"m/dd/yy") & CHAR(10) & " (" & E7 & ")" |
I want the X Axis labels to look like this, which they do very nicely using the data in Column F, which is generated from the data in Columns D & E.
Is there a way I can generate thise X Axis labels in the chart from the data in D & E and get rid of Column F?
Thanks