If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dynamic charts
I'm trying to construct a dynamic chart with a scroll function. Right
now row 1 contains my labels and row 2 contains my data. For example, a b c d 1 jan feb mar apr 2 $20 $30 $40 $50 I'm able to do it if I convert my data to where the months are in column a and the data is in column b. a b 1 jan $20 2 feb $30 3 mar $40 4 apr $50 All of the dynamic chart information that i have been able to find shows the data in columns. Is there a way where I don't have to convert my data to have it show the month in column a and the data in column b |
#2
|
|||
|
|||
dynamic charts
Dynamic range names work the same way for column based data or row based
data, you just have to keep track of what is changing. The generic offset formula is =Offset(sheet!$start cell, row_offset, col_offset, number rows, number_cols) For a dynamic column data set we use the = offset(sheet1!$a$1,0,0,counta(sheet1!$a:$a),1) For a dynamic row we use a similar formula, however, we vary the cols, not the rows = offset(sheet1!$a$1,0,1,counta(sheet1!$1:$1)) Once you set your months, you can set your data row as an offset to the months: = offset(months,1,0) ....Kelly "Kirk" wrote in message oups.com... I'm trying to construct a dynamic chart with a scroll function. Right now row 1 contains my labels and row 2 contains my data. For example, a b c d 1 jan feb mar apr 2 $20 $30 $40 $50 I'm able to do it if I convert my data to where the months are in column a and the data is in column b. a b 1 jan $20 2 feb $30 3 mar $40 4 apr $50 All of the dynamic chart information that i have been able to find shows the data in columns. Is there a way where I don't have to convert my data to have it show the month in column a and the data in column b |
#3
|
|||
|
|||
dynamic charts
The dynamic formulas use OFFSET, right? Look up OFFSET in the help files,
and see which arguments you need to adjust to make the formulas work in the transposed orientation. Hint: =OFFSET($A$1,RowOffset,ColOffset,RowsHigh,ColsWide ) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Kirk" wrote in message oups.com... I'm trying to construct a dynamic chart with a scroll function. Right now row 1 contains my labels and row 2 contains my data. For example, a b c d 1 jan feb mar apr 2 $20 $30 $40 $50 I'm able to do it if I convert my data to where the months are in column a and the data is in column b. a b 1 jan $20 2 feb $30 3 mar $40 4 apr $50 All of the dynamic chart information that i have been able to find shows the data in columns. Is there a way where I don't have to convert my data to have it show the month in column a and the data in column b |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
mail merging dynamic charts | chips | Charts and Charting | 0 | December 22nd, 2005 10:05 PM |
Can't create dynamic charts | Brian Sells | Charts and Charting | 7 | March 22nd, 2005 04:23 AM |
Dynamic Charts | Brian Sells | General Discussion | 2 | March 15th, 2005 12:09 PM |
strange problems with dynamic charts | Rebekah | Charts and Charting | 2 | February 27th, 2004 01:42 AM |