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
|
|||
|
|||
excel dynamic charts samples
Please send me excel dynamic charts samples. Thanks.
|
#2
|
|||
|
|||
excel dynamic charts samples
Hi,
http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm Cheers Andy kh wrote: Please send me excel dynamic charts samples. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
excel dynamic charts samples
Can dynamic charts work if the information is going horizontally instead of
vertically? Thanks! Larisa "Andy Pope" wrote: Hi, http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm Cheers Andy kh wrote: Please send me excel dynamic charts samples. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
excel dynamic charts samples
Yes. Adjust the OFFSET formula so that you specify 1 row and COUNTA(...) columns. On Tue, 13 May 2008 08:36:02 -0700, Larisa wrote: Can dynamic charts work if the information is going horizontally instead of vertically? Thanks! Larisa "Andy Pope" wrote: Hi, http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm Cheers Andy kh wrote: Please send me excel dynamic charts samples. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
excel dynamic charts samples
Sure can. You need to adjust the formulas that define the dynamic range. For
example, adjust the OFFSET formula. The references go like this: =OFFSET(reference range, rows down from reference range, columns right of reference range, rows high, columns wide) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Larisa" wrote in message ... Can dynamic charts work if the information is going horizontally instead of vertically? Thanks! Larisa "Andy Pope" wrote: Hi, http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm Cheers Andy kh wrote: Please send me excel dynamic charts samples. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
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 |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Can I import Excel charts into ACCESS for reporting? | Marjie | Setting Up & Running Reports | 0 | January 19th, 2005 06:31 PM |
Excel creates its own hidden charts that creates a corrupt file! | FlawedLojik | General Discussions | 0 | August 29th, 2004 05:43 PM |
Linked Excel Charts Resizing when Update Links | L. Mansfield | Powerpoint | 0 | May 19th, 2004 08:15 PM |