HELP!! 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 A, B, and C. Like i said, all 3 columns are dynamic formulas as well. Column A is mapped to a pivot table...when it changes based off slicers, then columns A-C change accordingly, thus my bar chart should only include the systems with data vs blank space on the chart. NA() isnt working nor is any other NA function. HELP!! 
I attached a link too, but not sure if i did it right. 
Thank you in advance!!
<code style="margin: 0px; padding: 0px; font-size: 1em; font-family: Monaco, 'Courier New', monospace;">A B C D Actual Target helper column (NOT charted) ARD Web 110 157 164Brutis 9 9 9CS2 #N/A #N/A #N/AKiosk #N/A 1 1Loyalty 9 16 17MDM #N/A #N/A #N/AQik #N/A 4 4.com/WDS 9 12 13OBS - SMP 24 26 27EI CE 7 7 7 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A</code></pre></pre>
https://www.dropbox.com/s/njfit46f3liy13l/forum%20example.xlsm
https://www.dropbox.com/s/njfit46f3liy13l/forum example.xlsm
I attached a link too, but not sure if i did it right. Thank you in advance!!<code style="margin: 0px; padding: 0px; font-size: 1em; font-family: Monaco, 'Courier New', monospace;">A B C D Actual Target helper column (NOT charted) ARD Web 110 157 164Brutis 9 9 9CS2 #N/A #N/A #N/AKiosk #N/A 1 1Loyalty 9 16 17MDM #N/A #N/A #N/AQik #N/A 4 4.com/WDS 9 12 13OBS - SMP 24 26 27EI CE 7 7 7 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A</code></pre></pre>
https://www.dropbox.com/s/njfit46f3liy13l/forum%20example.xlsm
https://www.dropbox.com/s/njfit46f3liy13l/forum example.xlsm
