Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Dynamic Chart

  1. #1
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Dynamic Chart

    Hi All,

    Here is some Samples of Dynamic Charts. I hope it's useful to you.

    Regards,
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,284

    Re: Dynamic Chart

    Hi Kris,

    Interesting use of the INDEX formula for getting the dynamic ranges, normally the OFFSET formula is used.

    Is there any advantage of using INDEX or benifit of not using OFFSET?

    Cheers
    Andy


  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Dynamic Chart

    Hi Andy,

    I think INDEX is a non-volatile function.

  4. #4
    Join Date
    30th June 2006
    Posts
    35

    Re: Dynamic Chart

    This is awesome stuff. But how do I start a dynamic chart. Also, how to put the chart on another sheet instead on the same sheet as the dataset. On the above example I can't seem to view the macro code. Anyways, awesome chart and if I could figure this out that would dramatically help me out w/ some stuff here at work. I have extensive amounts of data that could be used in this. Need to really look into creating this.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Dynamic Chart

    Hi,

    There is no macros inside the workbook. All are defined names.Hit Ctrl+F3 or goto Insert > Name > Define to see the formulas used to define the ranges. If you have more questions on chart, post on main forum.

    Regards,

  6. #6
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,749

    Re: Dynamic Chart

    Quote Originally Posted by drvortex
    This is awesome stuff. But how do I start a dynamic chart. Also, how to put the chart on another sheet instead on the same sheet as the dataset. On the above example I can't seem to view the macro code. Anyways, awesome chart and if I could figure this out that would dramatically help me out w/ some stuff here at work. I have extensive amounts of data that could be used in this. Need to really look into creating this.
    This forum is clearly marked "No Questions"

    Please ask your question in the appropriate Forum, referencing this Thread. Thanks
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  7. #7
    Join Date
    5th May 2011
    Posts
    1

    Re: Dynamic Chart

    Hi Kris,
    I am trying to make a report where in i have 4 fields

    Date
    Bank Transfer- Currency
    Credit voucher- currency
    Post Office Data- Currency

    I tried to work on the formula can you please explain me how can i work with this data in order to get automatic chart once i change these values.


    Regards,[/QUOTE]
    Sona

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Dynamic Chart
    By angshuman in forum Excel General
    Replies: 7
    Last Post: August 21st, 2007, 22:44
  2. Dynamic Pie Chart
    By alvinh in forum Excel General
    Replies: 1
    Last Post: July 31st, 2007, 14:40
  3. Dynamic Chart Add In
    By farhad in forum Excel General
    Replies: 8
    Last Post: July 5th, 2006, 17:04
  4. Dynamic Chart
    By farhad in forum Excel General
    Replies: 6
    Last Post: June 30th, 2006, 03:24
  5. Dynamic Chart
    By kenshin in forum Excel General
    Replies: 3
    Last Post: August 27th, 2004, 01:34

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno