Excel charts

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:29 PM GMT

Question

QUESTION: need to do with2007 a bar chart of the difference of two rows. the first cell of each row is the date of input but is only the label for the data. the second and the rest of cells of the rows are the data which I need to put in the chart, but I need only the last two rows each time, so when I capture the third row, the chart must show the difference between third and second row(b3-b2, c3-c2, etc), when I capture the fourth, the chart must show the difference between the fourth and third (b4-b3, c4-c3, etc) and so on. I have put a formula that give me the first cell of the row to be put as label of each column data, but I need to know what to do to have the explained.

Thanks in advance by your help

ANSWER: What do you mean by "when I capture the third row"? How does one capture a row?

---------- FOLLOW-UP ----------

QUESTION: I say that I capture a row when i fill the values of the 20 cells in the row to get the chart. My chart must draw the diference of the 20 values of the first row (cells B1 to U1)and the 20 values of the second row, (B2 to U2)and when i get more data (dayly, i think), and fill the cells of the third row, the graph shows the values of the difference between the third and the second rows, one, the chart show 20 bars, . the first bar in the chart shows the value of b2-b1, the second is c2-c1, and so on

When I fill the cell of the column A of each new row, the chart must display the diference between the las two rows: when I write the value for A3, the chart will show as first position b3-b2, the second c3-c2, and so on.

Thanks again

Answer

Adjust these ranges as necessary, but if you have them available this will work. in cell X1: =CELL("Address") in X2: =OFFSET(INDIRECT($X1),0,COLUMN(A1))-OFFSET(INDIRECT($X1),-1,COLUMN(A1)) Fill this right to AQ2. Select X2:AQ2 and make your chart (it will look odd now but hang on...) Now, when you type something in A3, A4, etc the chart will update to do as you requested.

HTH

Question

Mr. Resnick, I am making a chart of the S&P weekly closing average with the date, closing price, 20 week moving average and 39 week moving. When I do for some reason the plot values for the y- axis go as high a 4500 when the numbers are only like 1500. My other similar charts of the Dow Jones Industrial average are O.K. Please help. I can't figure out what is happening. I use windows vista and exel 2007. I have enclosed the first 50 weekly closing data and the moving averages.

Date 20 week moving average 39 week moving average Close 8/17/2006 1302.3 8/21/2006 1295.09 8/28/2006 1311.01 9/5/2006 1298.92 9/11/2006 1319.66 9/18/2006 1314.78 9/25/2006 1335.85 10/2/2006 1349.59 10/9/2006 1365.62 10/16/2006 1368.6 10/23/2006 1377.34 10/30/2006 1364.3 11/6/2006 1380.9 11/13/2006 1401.2 11/20/2006 1400.95 11/27/2006 1396.71 12/4/2006 1409.84 12/11/2006 1427.09 12/18/2006 1410.76 12/26/2006 1362.4405 1418.3 1/3/2007 1367.811 1409.71 1/8/2007 1374.593 1430.73 1/16/2007 1380.5675 1430.5 1/22/2007 1386.7305 1422.18 1/29/2007 1393.167 1448.39 2/5/2007 1399.331 1438.06 2/12/2007 1405.3155 1455.54 2/20/2007 1410.3955 1451.19 2/26/2007 1411.473 1387.17 3/5/2007 1413.185 1402.84 3/12/2007 1413.6655 1386.95 3/19/2007 1417.256 1436.11 3/26/2007 1419.254 1420.86 4/2/2007 1421.382 1443.76 4/9/2007 1423.977 1452.85 4/16/2007 1428.359 1484.35 4/23/2007 1432.5705 1494.07 4/30/2007 1436.497 1505.62 5/7/2007 1441.2515 1401.424103 1505.85 5/14/2007 1446.474 1440.468974 1522.75 5/21/2007 1451.775 1445.941538 1515.73 5/29/2007 1457.0555 1452.127436 1536.34 6/4/2007 1460.914 1457.17 1507.67 6/11/2007 1466.4505 1463.169744 1532.91 6/18/2007 1469.159 1467.859487 1502.56 6/25/2007 1472.4235 1472.694615 1503.35 7/2/2007 1476.1685 1477.684103 1530.44 7/9/2007 1481.234 1482.886923 1552.5 7/16/2007 1488.5805 1487.206923 1534.1

Answer

Select the chart. From the ribbon, choose Chart Tools, Layout, Axes, Primary Vertical Axis, More Primary Vertical Axis Options, Axis Options. In the Format Axis popup, under "Maximum:", choose Fixed, and enter whatever you want the maximum value of your y-Axis to be.

Advertisement

©2017 eLuminary LLC. All rights reserved.