I'm studing http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html trying to get at least one horizontal AND one vertical line in one chart, and want to know if it is possible to get multiple horizontal AND vertical lines in one chart?
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Version1: | singleHori&VertTargets | Version2: | multipleHori&VertTargets | |||||
2 | Month | NumberTrainingItemsComplete | Month | NumberTrainingItemsComplete | |||||
3 | Oct-06 | 2 | Oct-06 | 2 | |||||
4 | Nov-06 | 4 | Nov-06 | 4 | |||||
5 | Dec-06 | 6 | Dec-06 | 6 | |||||
6 | Jan-07 | 9 | Jan-07 | 9 | |||||
7 | Feb-07 | 10 | Feb-07 | 10 | |||||
8 | Mar-07 | 15 | Mar-07 | 15 | |||||
9 | Apr-07 | 15 | Apr-07 | 15 | |||||
10 | May-07 | 20 | May-07 | 20 | |||||
11 | Jun-07 | 22 | Jun-07 | 22 | |||||
12 | Jul-07 | 30 | Jul-07 | 30 | |||||
13 | Aug-07 | 35 | Aug-07 | 35 | |||||
14 | Sep-07 | 40 | Sep-07 | 40 | |||||
15 | Oct-07 | 45 | Oct-07 | 45 | |||||
16 | |||||||||
17 | (thiswouldbethehorizontalline) | (thiswouldbethehorizontalline) | |||||||
18 | Target | 45 | Target1 | 10 | |||||
19 | Target2 | 20 | |||||||
20 | Target3 | 30 | |||||||
21 | (thiswouldbetheverticalline) | Target4 | 45 | ||||||
22 | Milestone | Dec-07 | |||||||
23 | (thiswouldbetheverticalline) | ||||||||
24 | Milestone1 | Dec-07 | |||||||
25 | Milestone2 | Mar-07 | |||||||
26 | Milestone3 | Jun-07 | |||||||
27 | Milestone4 | Sep-07 | |||||||
Sheet1 |
Do you mean replace 11/9/02 with 1281 ??