+ Reply to Thread
Results 1 to 3 of 3

How to create a dynamic chart off dynamic data

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question How to create a dynamic chart off dynamic data

    Hey gang! I'm stumped! I am trying to create a dynamic BAR chart that changes with my data. The below is my data set which is dynamic as well. I've tried using OFFSET but i must be doing it wrong and need help ASAP if possible. I need to chart columns B, C, and D. Like i said, all 3 columns are formulas as well. Column B is mapped to a pivot table...when it changes based off slicers, then columns B-D change accordingly, thus my bar chart i need help with will change. HELP!!

    forum example.xlsm

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,618

    Re: How to create a dynamic chart off dynamic data

    Your workbook is locked for editing, I can't do anything with it.
    Would this link steer you in the right direction?
    http://www.excelforum.com/excel-prog...chart-vba.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    02-21-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to create a dynamic chart off dynamic data

    Jacc, the pw = codastatus. or open it read only. i'd put the file back on here, but dont see how to attach it again. Please take a peek at the file and if you can help me, wonderful. I'm in panic mode. yikes!!! LOL I will take a look at what you sent though.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create Dynamic chart from the data with boolean values and dates
    By kbaruin in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-24-2012, 03:45 AM
  2. Replies: 1
    Last Post: 09-20-2012, 12:13 PM
  3. Can I create a dynamic chart with a dynamic number of series?
    By SG2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-24-2011, 08:44 AM
  4. [SOLVED] How do I create a dynamic chart
    By Nick Krill in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-21-2006, 04:25 PM
  5. How to create a dynamic chart using data from every 7th data row
    By Ralph in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-18-2005, 02:00 PM

Tags for this Thread

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