Results 1 to 8 of 8

Turn Dynamic Horizontal Chart into 12-month rolling

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Turn Dynamic Horizontal Chart into 12-month rolling

    Hello I am having trouble turning the Dynamic Chart attached into a 12-month rolling chart. I am not very familiar at all with the Offset formula as well as Ranges and would greatly appreciate it if someone can help me. I created a very simple dynamic chart which has been modified from the most commonly known out there to work with horizontal data and Vlookups, thanks to Andy Pope from an older post linked below. I would like to know where to insert code into the Range formulas (CTL-F3) which would create a 12-month rolling chart. Thank you once again to any that could help!

    Referenced old thread
    http://www.excelforum.com/excel-char...tal-table.html

    Vertical Dynamic 12-month rolling chart (w/out Vlookup solution modification)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1