Announcement

Collapse
No announcement yet.

Dynamic Chart

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dynamic Chart



    Hi All,

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

    Regards,
    Attached Files
    Kris

    ExcelFox

  • #2
    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

    Comment


    • #3
      Re: Dynamic Chart

      Hi Andy,

      I think INDEX is a non-volatile function.
      Kris

      ExcelFox

      Comment


      • #4
        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.

        Comment


        • #5
          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,
          Kris

          ExcelFox

          Comment


          • #6
            Re: Dynamic Chart

            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

            RoyUK's Web Site

            royUK's Database Form

            Where to paste code from the Forum

            About me.

            Comment


            • #7


              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

              Comment

              Working...
              X