CHARTING Stocks Price and Volume

chuckchuckit

Well-known Member
Joined
Sep 18, 2010
Messages
541
Programming Excel VBA for about a year and very familiar with queries and data handling, but not with charting.

I am starting to do charting for stocks and need both PRICE (line chart), and VOLUME (vertical bar chart), both on same chart.

One way, seems there is a "dynamic" way to chart. By selecting cells data, then choosing Insert Table, then insert Line Chart. This way seems good for updating charts every minute (dynamic). But can't find the way to put price (line chart), and volume (bar chart) in same chart.

Or a 2nd way, seems to be to select data then push F11 and a chart pops up. A Youtube video goes that route:

http://www.youtube.com/watch?v=8lo9WnKlsKI

Would need many charts per worksheet.

What would my best route to start the learning curve?

Thanks.

Chuck
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You can use named ranges as the references for graph series.

If you click on a graph series, you get a formula like this:
=SERIES(,'Data Input'!$A$1:$A$4,'Data Input'!$B$1:$B$4,1)

If you change the formula from a fixed range to a named range, you can create named ranges to cover whatever it is you need done (assuming there's logic to how you get your data).
 
Upvote 0
Thanks Sal,

Getting the data part is done.

I am just wondering which of those two charting procedures would be best to use?

I was hoping to use the 1st one as it is dynamic and will update itself when ever data is added, but I cannot get the verticle bar chart and horizontal line chart to work together in that 1st way.

Chuck
 
Upvote 0
Have you managed to get both graph types in the same chart yet? I haven't had much luck (the category axis doesn't like plotting time in small segments like minutes). If it's just a matter of getting an existing chart working, it's much easier than asking to create a new chart type that isn't normally supported.
 
Upvote 0
I have not gotten the two to work together in that 1st way. I could always have 2 charts with one below the other, but that does not seem a practical way. I found some posts in searching that said they have done it but they did not say how.

I have not had a chance yet to look at all of this video which does do both charts on one screen:

http://www.youtube.com/watch?v=8lo9WnKlsKI

But was just thinking before I go too far into one or the other, that was thinking someone here had already experienced the answer.

Thanks.

Chuck
 
Upvote 0
It can be done:

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style=";">Price</td><td style=";">Volume</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Updated Volume</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Gap Width</td><td style="text-align: right;;">20%</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">2011/9/1 14:00</td><td style="text-align: right;;">100</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style=";">1-1</td><td style=";">1-1</td><td style="text-align: right;;">42.6667</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Data Points</td><td style="text-align: right;;">24</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">2011/9/1 15:00</td><td style="text-align: right;;">113</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style=";">1-2</td><td style=";">1-2</td><td style="text-align: right;;">42.6667</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Gap1</td><td style="text-align: right;;">42.66667</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">2011/9/1 16:00</td><td style="text-align: right;;">114.13</td><td style="text-align: right;;">43355</td><td style="text-align: right;;"></td><td style=";">1-3</td><td style=";">1-3</td><td style="text-align: right;;">376</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Gap2</td><td style="text-align: right;;">83.33333</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">2011/9/1 17:00</td><td style="text-align: right;;">134.6734</td><td style="text-align: right;;">44744</td><td style="text-align: right;;"></td><td style=";">1-4</td><td style=";">1-4</td><td style="text-align: right;;">376</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">ColWidth</td><td style="text-align: right;;">333.3333</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">2011/9/1 18:00</td><td style="text-align: right;;">149.4875</td><td style="text-align: right;;">34499</td><td style="text-align: right;;"></td><td style=";">2-1</td><td style=";">2-1</td><td style="text-align: right;;">459.333</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">2011/9/1 19:00</td><td style="text-align: right;;">131.549</td><td style="text-align: right;;">48541</td><td style="text-align: right;;"></td><td style=";">2-2</td><td style=";">1-1</td><td style="text-align: right;;">459.333</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">2011/9/1 20:00</td><td style="text-align: right;;">151.2813</td><td style="text-align: right;;">34543</td><td style="text-align: right;;"></td><td style=";">2-3</td><td style=";">1-1</td><td style="text-align: right;;">792.667</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">2011/9/1 21:00</td><td style="text-align: right;;">164.8966</td><td style="text-align: right;;">46348</td><td style="text-align: right;;"></td><td style=";">2-4</td><td style=";">1-1</td><td style="text-align: right;;">792.667</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">2011/9/1 22:00</td><td style="text-align: right;;">131.9173</td><td style="text-align: right;;">40022</td><td style="text-align: right;;"></td><td style=";">3-1</td><td style=";">1-1</td><td style="text-align: right;;">876</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">2011/9/1 23:00</td><td style="text-align: right;;">143.7899</td><td style="text-align: right;;">49738</td><td style="text-align: right;;"></td><td style=";">3-2</td><td style=";">1-1</td><td style="text-align: right;;">876</td><td style="text-align: right;;">43355</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">2011/9/2 0:00</td><td style="text-align: right;;">155.2931</td><td style="text-align: right;;">45743</td><td style="text-align: right;;"></td><td style=";">3-3</td><td style=";">1-1</td><td style="text-align: right;;">1209.33</td><td style="text-align: right;;">43355</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">2011/9/2 1:00</td><td style="text-align: right;;">130.4462</td><td style="text-align: right;;">39596</td><td style="text-align: right;;"></td><td style=";">3-4</td><td style=";">1-1</td><td style="text-align: right;;">1209.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">2011/9/2 2:00</td><td style="text-align: right;;">121.3149</td><td style="text-align: right;;">38356</td><td style="text-align: right;;"></td><td style=";">4-1</td><td style=";">1-1</td><td style="text-align: right;;">1292.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">2011/9/2 3:00</td><td style="text-align: right;;">129.807</td><td style="text-align: right;;">32754</td><td style="text-align: right;;"></td><td style=";">4-2</td><td style=";">1-1</td><td style="text-align: right;;">1292.67</td><td style="text-align: right;;">44744</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">2011/9/2 4:00</td><td style="text-align: right;;">153.1722</td><td style="text-align: right;;">41644</td><td style="text-align: right;;"></td><td style=";">4-3</td><td style=";">1-1</td><td style="text-align: right;;">1626</td><td style="text-align: right;;">44744</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">2011/9/2 5:00</td><td style="text-align: right;;">137.855</td><td style="text-align: right;;">49785</td><td style="text-align: right;;"></td><td style=";">4-4</td><td style=";">1-1</td><td style="text-align: right;;">1626</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">2011/9/2 6:00</td><td style="text-align: right;;">118.5553</td><td style="text-align: right;;">49478</td><td style="text-align: right;;"></td><td style=";">5-1</td><td style=";">1-1</td><td style="text-align: right;;">1709.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">2011/9/2 7:00</td><td style="text-align: right;;">135.1531</td><td style="text-align: right;;">45197</td><td style="text-align: right;;"></td><td style=";">5-2</td><td style=";">1-1</td><td style="text-align: right;;">1709.33</td><td style="text-align: right;;">34499</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">2011/9/2 8:00</td><td style="text-align: right;;">122.9893</td><td style="text-align: right;;">44654</td><td style="text-align: right;;"></td><td style=";">5-3</td><td style=";">1-1</td><td style="text-align: right;;">2042.67</td><td style="text-align: right;;">34499</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">2011/9/2 9:00</td><td style="text-align: right;;">109.4605</td><td style="text-align: right;;">35104</td><td style="text-align: right;;"></td><td style=";">5-4</td><td style=";">1-1</td><td style="text-align: right;;">2042.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">2011/9/2 10:00</td><td style="text-align: right;;">113.8389</td><td style="text-align: right;;">35627</td><td style="text-align: right;;"></td><td style=";">6-1</td><td style=";">1-1</td><td style="text-align: right;;">2126</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">2011/9/2 11:00</td><td style="text-align: right;;">94.48627</td><td style="text-align: right;;">30405</td><td style="text-align: right;;"></td><td style=";">6-2</td><td style=";">1-1</td><td style="text-align: right;;">2126</td><td style="text-align: right;;">48541</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">2011/9/2 12:00</td><td style="text-align: right;;">92.59655</td><td style="text-align: right;;">40574</td><td style="text-align: right;;"></td><td style=";">6-3</td><td style=";">1-1</td><td style="text-align: right;;">2459.33</td><td style="text-align: right;;">48541</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">2011/9/2 13:00</td><td style="text-align: right;;">111.1159</td><td style="text-align: right;;">31864</td><td style="text-align: right;;"></td><td style=";">6-4</td><td style=";">1-1</td><td style="text-align: right;;">2459.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">7-1</td><td style=";">1-1</td><td style="text-align: right;;">2542.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">7-2</td><td style=";">1-1</td><td style="text-align: right;;">2542.67</td><td style="text-align: right;;">34543</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">7-3</td><td style=";">1-1</td><td style="text-align: right;;">2876</td><td style="text-align: right;;">34543</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">7-4</td><td style=";">1-1</td><td style="text-align: right;;">2876</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">8-1</td><td style=";">1-1</td><td style="text-align: right;;">2959.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">8-2</td><td style=";">1-1</td><td style="text-align: right;;">2959.33</td><td style="text-align: right;;">46348</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">8-3</td><td style=";">1-1</td><td style="text-align: right;;">3292.67</td><td style="text-align: right;;">46348</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">8-4</td><td style=";">1-1</td><td style="text-align: right;;">3292.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">9-1</td><td style=";">1-1</td><td style="text-align: right;;">3376</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">9-2</td><td style=";">1-1</td><td style="text-align: right;;">3376</td><td style="text-align: right;;">40022</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">9-3</td><td style=";">1-1</td><td style="text-align: right;;">3709.33</td><td style="text-align: right;;">40022</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">9-4</td><td style=";">1-1</td><td style="text-align: right;;">3709.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">10-1</td><td style=";">1-1</td><td style="text-align: right;;">3792.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">10-2</td><td style=";">1-1</td><td style="text-align: right;;">3792.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">10-3</td><td style=";">1-1</td><td style="text-align: right;;">4126</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">10-4</td><td style=";">1-1</td><td style="text-align: right;;">4126</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">11-1</td><td style=";">1-1</td><td style="text-align: right;;">4209.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">11-2</td><td style=";">1-1</td><td style="text-align: right;;">4209.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">44</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">11-3</td><td style=";">1-1</td><td style="text-align: right;;">4542.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">45</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">11-4</td><td style=";">1-1</td><td style="text-align: right;;">4542.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">46</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">12-1</td><td style=";">1-1</td><td style="text-align: right;;">4626</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">47</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">12-2</td><td style=";">1-1</td><td style="text-align: right;;">4626</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">48</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">12-3</td><td style=";">1-1</td><td style="text-align: right;;">4959.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">49</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">12-4</td><td style=";">1-1</td><td style="text-align: right;;">4959.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">50</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">13-1</td><td style=";">1-1</td><td style="text-align: right;;">5042.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">51</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">13-2</td><td style=";">1-1</td><td style="text-align: right;;">5042.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">52</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">13-3</td><td style=";">1-1</td><td style="text-align: right;;">5376</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">53</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">13-4</td><td style=";">1-1</td><td style="text-align: right;;">5376</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">54</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">14-1</td><td style=";">1-1</td><td style="text-align: right;;">5459.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">55</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">14-2</td><td style=";">1-1</td><td style="text-align: right;;">5459.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">56</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">14-3</td><td style=";">1-1</td><td style="text-align: right;;">5792.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">57</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">14-4</td><td style=";">1-1</td><td style="text-align: right;;">5792.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">58</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">15-1</td><td style=";">1-1</td><td style="text-align: right;;">5876</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">59</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">15-2</td><td style=";">1-1</td><td style="text-align: right;;">5876</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">60</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">15-3</td><td style=";">1-1</td><td style="text-align: right;;">6209.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">61</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">15-4</td><td style=";">1-1</td><td style="text-align: right;;">6209.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">62</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">16-1</td><td style=";">1-1</td><td style="text-align: right;;">6292.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">63</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">16-2</td><td style=";">1-1</td><td style="text-align: right;;">6292.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">64</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">16-3</td><td style=";">1-1</td><td style="text-align: right;;">6626</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">65</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">16-4</td><td style=";">1-1</td><td style="text-align: right;;">6626</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">66</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">17-1</td><td style=";">1-1</td><td style="text-align: right;;">6709.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">67</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">17-2</td><td style=";">1-1</td><td style="text-align: right;;">6709.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">68</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">17-3</td><td style=";">1-1</td><td style="text-align: right;;">7042.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">69</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">17-4</td><td style=";">1-1</td><td style="text-align: right;;">7042.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">70</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">18-1</td><td style=";">1-1</td><td style="text-align: right;;">7126</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">71</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">18-2</td><td style=";">1-1</td><td style="text-align: right;;">7126</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">72</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">18-3</td><td style=";">1-1</td><td style="text-align: right;;">7459.33</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">73</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">18-4</td><td style=";">1-1</td><td style="text-align: right;;">7459.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">74</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">19-1</td><td style=";">1-1</td><td style="text-align: right;;">7542.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">75</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">19-2</td><td style=";">1-1</td><td style="text-align: right;;">7542.67</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">76</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">19-3</td><td style=";">1-1</td><td style="text-align: right;;">7876</td><td style="text-align: right;;">43801</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">77</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">19-4</td><td style=";">1-1</td><td style="text-align: right;;">7876</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">78</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">20-1</td><td style=";">1-1</td><td style="text-align: right;;">7959.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">79</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">20-2</td><td style=";">1-1</td><td style="text-align: right;;">7959.33</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">80</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">20-3</td><td style=";">1-1</td><td style="text-align: right;;">8292.67</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">81</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">20-4</td><td style=";">1-1</td><td style="text-align: right;;">8292.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">82</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">21-1</td><td style=";">1-1</td><td style="text-align: right;;">8376</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">83</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">21-2</td><td style=";">1-1</td><td style="text-align: right;;">8376</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">84</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">21-3</td><td style=";">1-1</td><td style="text-align: right;;">8709.33</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">85</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">21-4</td><td style=";">1-1</td><td style="text-align: right;;">8709.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">86</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">22-1</td><td style=";">1-1</td><td style="text-align: right;;">8792.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">87</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">22-2</td><td style=";">1-1</td><td style="text-align: right;;">8792.67</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">88</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">22-3</td><td style=";">1-1</td><td style="text-align: right;;">9126</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">89</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">22-4</td><td style=";">1-1</td><td style="text-align: right;;">9126</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">90</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">23-1</td><td style=";">1-1</td><td style="text-align: right;;">9209.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">91</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">23-2</td><td style=";">1-1</td><td style="text-align: right;;">9209.33</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">92</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">23-3</td><td style=";">1-1</td><td style="text-align: right;;">9542.67</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">93</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">23-4</td><td style=";">1-1</td><td style="text-align: right;;">9542.67</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">94</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">24-1</td><td style=";">1-1</td><td style="text-align: right;;">9626</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">95</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">24-2</td><td style=";">1-1</td><td style="text-align: right;;">9626</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">96</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">24-3</td><td style=";">1-1</td><td style="text-align: right;;">9959.33</td><td style="text-align: right;;">31649</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">97</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">24-4</td><td style=";">1-1</td><td style="text-align: right;;">9959.33</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H3</th><td style="text-align:left">=INDEX(<font color="Blue">$C$2:$C$25,LEFT(<font color="Red">E3,1</font>)*1,</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H4</th><td style="text-align:left">=H3</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H6</th><td style="text-align:left">=H5</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H7</th><td style="text-align:left">=INDEX(<font color="Blue">$C$2:$C$25,LEFT(<font color="Red">E7,1</font>)*1,</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H8</th><td style="text-align:left">=H7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G2</th><td style="text-align:left">=L3</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G3</th><td style="text-align:left">=G2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G4</th><td style="text-align:left">=G3+$L$5</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G5</th><td style="text-align:left">=G4</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G6</th><td style="text-align:left">=G5+$L$4</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G7</th><td style="text-align:left">=G6</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G8</th><td style="text-align:left">=G7+$L$5</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G9</th><td style="text-align:left">=G8</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G10</th><td style="text-align:left">=G9+$L$4</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H10</th><td style="text-align:left">=H9</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L3</th><td style="text-align:left">=(<font color="Blue">1/L2*(<font color="Red">L1/2</font>)</font>)*10000+1</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L4</th><td style="text-align:left">=(<font color="Blue">1/L2*(<font color="Red">L1</font>)</font>)*10000</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L5</th><td style="text-align:left">=(<font color="Blue">1/L2*(<font color="Red">1-L1</font>)</font>)*10000</td></tr></tbody></table></td></tr></table><br />

You would plot columns G and H as an area graph. Then select columns A:B and copy-paste special into the graph (new series). Then you'd change the "Price" Series to an X-Y chart and go to graph options and make a secondary chart axis. The area chart would need to have a time-scale X-axis with a min of 0 (1900/1/0 0:00), and a max of 10000 (1927/5/18 0:00). The other axis would stay x-y but would need time/date values entered numerically for the max/min. Alternatively, you could make dummy labels on the X axis and make the values something more reasonable, using the dummy labels to show the dates of the data being displayed.

However, the whole exercise is a bit pointless in most cases because plotting two totally different values on the same graph with two axes doesn't really make for good visual analysis. I'd make two separate charts -- Price on the top, with volume as a very short bar chart on the bottom. All your charts could share the same scale, making it easy to compare between stocks. If you want to be able to visually distinguish between heavy and light trading, I'd make the bar chart change the bar colors if trading gets extra heavy or whatnot.

But putting both types of graphs on the same two-axis chart is a huge hassle and really not worth the work.
 
Upvote 0
Got it started anyway.

Highlight 2 columns of data. Insert Table, Insert Line Chart. Click on one of the line types in chart, then in Design, Change Chart Type to column.

At least that got a line graph and a verticle bar chart working together on same chart. Much polish from there to get them dialed in and useable...

P.S. And now I just saw your post so I'll check that out.

BTW I have Excel 2007

Thanks.
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top