Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Question about Dynamic Charts
Using the examples found at
http://www.tushar-mehta.com/excel/ne...tml#BasicRange I was able to create a dynamic chart as shown. However, does anyone know of any examples where the data is row based (as opposed to column based?)... I had difficulty figuring how to switch it up. Thanks, Adam |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Question about Dynamic Charts
I found an example that works: http://www.primeconsultin.com/faqs/faq4650.html
"Adam" wrote: Using the examples found at http://www.tushar-mehta.com/excel/ne...tml#BasicRange I was able to create a dynamic chart as shown. However, does anyone know of any examples where the data is row based (as opposed to column based?)... I had difficulty figuring how to switch it up. Thanks, Adam |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Question about Dynamic Charts
If you read the explanation about the OFFSET function, and if necessary
refer to the help files, you will see that the parameters in OFFSET refer alternatively to row and column measurements. Swap the arguments within the function, and you can work with row- or column-based ranges. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Adam" wrote in message ... Using the examples found at http://www.tushar-mehta.com/excel/ne...tml#BasicRange I was able to create a dynamic chart as shown. However, does anyone know of any examples where the data is row based (as opposed to column based?)... I had difficulty figuring how to switch it up. Thanks, Adam |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Question about Dynamic Charts
I didn't mean that to sound snide. Please don't take offense.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote in message ... If you read the explanation about the OFFSET function, and if necessary refer to the help files, you will see that the parameters in OFFSET refer alternatively to row and column measurements. Swap the arguments within the function, and you can work with row- or column-based ranges. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Adam" wrote in message ... Using the examples found at http://www.tushar-mehta.com/excel/ne...tml#BasicRange I was able to create a dynamic chart as shown. However, does anyone know of any examples where the data is row based (as opposed to column based?)... I had difficulty figuring how to switch it up. Thanks, Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart question | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
a question regarding dynamic ranges and charts | Charts and Charting in Excel | |||
Can I post dynamic line charts by swapping out .cvs files??? | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |