NidhiBhardwaj
New Member
- Joined
- Sep 18, 2014
- Messages
- 1
Hi Guys
I need to create a chart with the following data I need to have months/Weeks on X axis and projects and two series of Actual and Planned :-
Can you guide me with the steps to be followed for the same
I need to compare Actual against the planned hours per project per month per week..
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL span=19></COLGROUP>
I need to create a chart with the following data I need to have months/Weeks on X axis and projects and two series of Actual and Planned :-
Can you guide me with the steps to be followed for the same
I need to compare Actual against the planned hours per project per month per week..
| Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Jan-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Feb-14</SPAN> | Mar-14</SPAN> | Mar-14</SPAN> | Mar-14</SPAN> | ||
| Week - 2</SPAN> | Week - 2</SPAN> | Week - 3</SPAN> | Week - 3</SPAN> | Week - 4</SPAN> | Week - 4</SPAN> | Week - 5</SPAN> | Week - 5</SPAN> | Week - 1</SPAN> | Week - 1</SPAN> | Week - 6</SPAN> | Week - 6</SPAN> | Week - 7</SPAN> | Week - 7</SPAN> | Week - 8</SPAN> | Week - 8</SPAN> | Week - 9</SPAN> | Week - 9</SPAN> | Week - 9</SPAN> | Week - 9</SPAN> | Week - 10</SPAN> | ||
| Project Name</SPAN> | WBS</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> | Actual hours</SPAN> | Planned Hours</SPAN> |
| A</SPAN> | 1</SPAN> | 22</SPAN> | 32</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> | 24</SPAN> | 32</SPAN> | 24</SPAN> | 22</SPAN> | 32</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> | 24</SPAN> | 32</SPAN> | 24</SPAN> | 22</SPAN> | 32</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> |
| A</SPAN> | 2</SPAN> | 22</SPAN> | 32</SPAN> | 23</SPAN> | 33</SPAN> | 32</SPAN> | 24</SPAN> | 33</SPAN> | 25</SPAN> | 22</SPAN> | 32</SPAN> | 23</SPAN> | 33</SPAN> | 32</SPAN> | 24</SPAN> | 33</SPAN> | 25</SPAN> | 22</SPAN> | 32</SPAN> | 23</SPAN> | 33</SPAN> | 32</SPAN> |
| A</SPAN> | 3</SPAN> | 22</SPAN> | 32</SPAN> | 24</SPAN> | 34</SPAN> | 32</SPAN> | 24</SPAN> | 34</SPAN> | 26</SPAN> | 22</SPAN> | 32</SPAN> | 24</SPAN> | 34</SPAN> | 32</SPAN> | 24</SPAN> | 34</SPAN> | 26</SPAN> | 22</SPAN> | 32</SPAN> | 24</SPAN> | 34</SPAN> | 32</SPAN> |
| A</SPAN> | 4</SPAN> | 22</SPAN> | 32</SPAN> | 25</SPAN> | 35</SPAN> | 32</SPAN> | 24</SPAN> | 35</SPAN> | 27</SPAN> | 22</SPAN> | 32</SPAN> | 25</SPAN> | 35</SPAN> | 32</SPAN> | 24</SPAN> | 35</SPAN> | 27</SPAN> | 22</SPAN> | 32</SPAN> | 25</SPAN> | 35</SPAN> | 32</SPAN> |
| A</SPAN> | 5</SPAN> | 22</SPAN> | 32</SPAN> | 26</SPAN> | 36</SPAN> | 32</SPAN> | 24</SPAN> | 36</SPAN> | 28</SPAN> | 22</SPAN> | 32</SPAN> | 26</SPAN> | 36</SPAN> | 32</SPAN> | 24</SPAN> | 36</SPAN> | 28</SPAN> | 22</SPAN> | 32</SPAN> | 26</SPAN> | 36</SPAN> | 32</SPAN> |
| A</SPAN> | 6</SPAN> | 22</SPAN> | 32</SPAN> | 27</SPAN> | 37</SPAN> | 32</SPAN> | 24</SPAN> | 37</SPAN> | 29</SPAN> | 22</SPAN> | 32</SPAN> | 27</SPAN> | 37</SPAN> | 32</SPAN> | 24</SPAN> | 37</SPAN> | 29</SPAN> | 22</SPAN> | 32</SPAN> | 27</SPAN> | 37</SPAN> | 32</SPAN> |
| A</SPAN> | 7</SPAN> | 22</SPAN> | 32</SPAN> | 28</SPAN> | 38</SPAN> | 32</SPAN> | 24</SPAN> | 38</SPAN> | 30</SPAN> | 22</SPAN> | 32</SPAN> | 28</SPAN> | 38</SPAN> | 32</SPAN> | 24</SPAN> | 38</SPAN> | 30</SPAN> | 22</SPAN> | 32</SPAN> | 28</SPAN> | 38</SPAN> | 32</SPAN> |
| A</SPAN> | 8</SPAN> | 22</SPAN> | 32</SPAN> | 29</SPAN> | 39</SPAN> | 32</SPAN> | 24</SPAN> | 39</SPAN> | 31</SPAN> | 22</SPAN> | 32</SPAN> | 29</SPAN> | 39</SPAN> | 32</SPAN> | 24</SPAN> | 39</SPAN> | 31</SPAN> | 22</SPAN> | 32</SPAN> | 29</SPAN> | 39</SPAN> | 32</SPAN> |
| A</SPAN> | 9</SPAN> | 22</SPAN> | 32</SPAN> | 30</SPAN> | 40</SPAN> | 32</SPAN> | 24</SPAN> | 40</SPAN> | 32</SPAN> | 22</SPAN> | 32</SPAN> | 30</SPAN> | 40</SPAN> | 32</SPAN> | 24</SPAN> | 40</SPAN> | 32</SPAN> | 22</SPAN> | 32</SPAN> | 30</SPAN> | 40</SPAN> | 32</SPAN> |
| A</SPAN> | 10</SPAN> | 22</SPAN> | 32</SPAN> | 31</SPAN> | 41</SPAN> | 32</SPAN> | 24</SPAN> | 41</SPAN> | 33</SPAN> | 22</SPAN> | 32</SPAN> | 31</SPAN> | 41</SPAN> | 32</SPAN> | 24</SPAN> | 41</SPAN> | 33</SPAN> | 22</SPAN> | 32</SPAN> | 31</SPAN> | 41</SPAN> | 32</SPAN> |
| A</SPAN> | 11</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> | 42</SPAN> | 32</SPAN> | 24</SPAN> | 42</SPAN> | 34</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> | 42</SPAN> | 32</SPAN> | 24</SPAN> | 42</SPAN> | 34</SPAN> | 22</SPAN> | 32</SPAN> | 32</SPAN> | 42</SPAN> | 32</SPAN> |
| A</SPAN> | 12</SPAN> | 22</SPAN> | 32</SPAN> | 33</SPAN> | 43</SPAN> | 32</SPAN> | 24</SPAN> | 43</SPAN> | 35</SPAN> | 22</SPAN> | 32</SPAN> | 33</SPAN> | 43</SPAN> | 32</SPAN> | 24</SPAN> | 43</SPAN> | 35</SPAN> | 22</SPAN> | 32</SPAN> | 33</SPAN> | 43</SPAN> | 32</SPAN> |
| B</SPAN> | 13</SPAN> | 22</SPAN> | 32</SPAN> | 34</SPAN> | 44</SPAN> | 32</SPAN> | 24</SPAN> | 44</SPAN> | 36</SPAN> | 22</SPAN> | 32</SPAN> | 34</SPAN> | 44</SPAN> | 32</SPAN> | 24</SPAN> | 44</SPAN> | 36</SPAN> | 22</SPAN> | 32</SPAN> | 34</SPAN> | 44</SPAN> | 32</SPAN> |
| B</SPAN> | 14</SPAN> | 22</SPAN> | 32</SPAN> | 35</SPAN> | 45</SPAN> | 32</SPAN> | 24</SPAN> | 45</SPAN> | 37</SPAN> | 22</SPAN> | 32</SPAN> | 35</SPAN> | 45</SPAN> | 32</SPAN> | 24</SPAN> | 45</SPAN> | 37</SPAN> | 22</SPAN> | 32</SPAN> | 35</SPAN> | 45</SPAN> | 32</SPAN> |
| B</SPAN> | 15</SPAN> | 22</SPAN> | 32</SPAN> | 36</SPAN> | 46</SPAN> | 32</SPAN> | 24</SPAN> | 46</SPAN> | 38</SPAN> | 22</SPAN> | 32</SPAN> | 36</SPAN> | 46</SPAN> | 32</SPAN> | 24</SPAN> | 46</SPAN> | 38</SPAN> | 22</SPAN> | 32</SPAN> | 36</SPAN> | 46</SPAN> | 32</SPAN> |
| B</SPAN> | 16</SPAN> | 22</SPAN> | 32</SPAN> | 37</SPAN> | 47</SPAN> | 32</SPAN> | 24</SPAN> | 47</SPAN> | 39</SPAN> | 22</SPAN> | 32</SPAN> | 37</SPAN> | 47</SPAN> | 32</SPAN> | 24</SPAN> | 47</SPAN> | 39</SPAN> | 22</SPAN> | 32</SPAN> | 37</SPAN> | 47</SPAN> | 32</SPAN> |
| B</SPAN> | 17</SPAN> | 22</SPAN> | 32</SPAN> | 38</SPAN> | 48</SPAN> | 32</SPAN> | 24</SPAN> | 48</SPAN> | 40</SPAN> | 22</SPAN> | 32</SPAN> | 38</SPAN> | 48</SPAN> | 32</SPAN> | 24</SPAN> | 48</SPAN> | 40</SPAN> | 22</SPAN> | 32</SPAN> | 38</SPAN> | 48</SPAN> | 32</SPAN> |
| B</SPAN> | 18</SPAN> | 22</SPAN> | 32</SPAN> | 39</SPAN> | 49</SPAN> | 32</SPAN> | 24</SPAN> | 49</SPAN> | 41</SPAN> | 22</SPAN> | 32</SPAN> | 39</SPAN> | 49</SPAN> | 32</SPAN> | 24</SPAN> | 49</SPAN> | 41</SPAN> | 22</SPAN> | 32</SPAN> | 39</SPAN> | 49</SPAN> | 32</SPAN> |
| B</SPAN> | 19</SPAN> | 22</SPAN> | 32</SPAN> | 40</SPAN> | 50</SPAN> | 32</SPAN> | 24</SPAN> | 50</SPAN> | 42</SPAN> | 22</SPAN> | 32</SPAN> | 40</SPAN> | 50</SPAN> | 32</SPAN> | 24</SPAN> | 50</SPAN> | 42</SPAN> | 22</SPAN> | 32</SPAN> | 40</SPAN> | 50</SPAN> | 32</SPAN> |
| B</SPAN> | 20</SPAN> | 22</SPAN> | 32</SPAN> | 41</SPAN> | 51</SPAN> | 32</SPAN> | 24</SPAN> | 51</SPAN> | 43</SPAN> | 22</SPAN> | 32</SPAN> | 41</SPAN> | 51</SPAN> | 32</SPAN> | 24</SPAN> | 51</SPAN> | 43</SPAN> | 22</SPAN> | 32</SPAN> | 41</SPAN> | 51</SPAN> | 32</SPAN> |
| B</SPAN> | 21</SPAN> | 22</SPAN> | 32</SPAN> | 42</SPAN> | 52</SPAN> | 32</SPAN> | 24</SPAN> | 52</SPAN> | 44</SPAN> | 22</SPAN> | 32</SPAN> | 42</SPAN> | 52</SPAN> | 32</SPAN> | 24</SPAN> | 52</SPAN> | 44</SPAN> | 22</SPAN> | 32</SPAN> | 42</SPAN> | 52</SPAN> | 32</SPAN> |
| B</SPAN> | 22</SPAN> | 22</SPAN> | 32</SPAN> | 43</SPAN> | 53</SPAN> | 32</SPAN> | 24</SPAN> | 53</SPAN> | 45</SPAN> | 22</SPAN> | 32</SPAN> | 43</SPAN> | 53</SPAN> | 32</SPAN> | 24</SPAN> | 53</SPAN> | 45</SPAN> | 22</SPAN> | 32</SPAN> | 43</SPAN> | 53</SPAN> | 32</SPAN> |
| B</SPAN> | 23</SPAN> | 22</SPAN> | 32</SPAN> | 44</SPAN> | 54</SPAN> | 32</SPAN> | 24</SPAN> | 54</SPAN> | 46</SPAN> | 22</SPAN> | 32</SPAN> | 44</SPAN> | 54</SPAN> | 32</SPAN> | 24</SPAN> | 54</SPAN> | 46</SPAN> | 22</SPAN> | 32</SPAN> | 44</SPAN> | 54</SPAN> | 32</SPAN> |
| B</SPAN> | 24</SPAN> | 22</SPAN> | 32</SPAN> | 45</SPAN> | 55</SPAN> | 32</SPAN> | 24</SPAN> | 55</SPAN> | 47</SPAN> | 22</SPAN> | 32</SPAN> | 45</SPAN> | 55</SPAN> | 32</SPAN> | 24</SPAN> | 55</SPAN> | 47</SPAN> | 22</SPAN> | 32</SPAN> | 45</SPAN> | 55</SPAN> | 32</SPAN> |
| B</SPAN> | 25</SPAN> | 22</SPAN> | 32</SPAN> | 46</SPAN> | 56</SPAN> | 32</SPAN> | 24</SPAN> | 56</SPAN> | 48</SPAN> | 22</SPAN> | 32</SPAN> | 46</SPAN> | 56</SPAN> | 32</SPAN> | 24</SPAN> | 56</SPAN> | 48</SPAN> | 22</SPAN> | 32</SPAN> | 46</SPAN> | 56</SPAN> | 32</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL span=19></COLGROUP>
