How to create a dynamic chart off dynamic data that has formulas???

[gizmo]

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 A, B, and C. Like i said, all 3 columns are 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 i need help with will change. HELP!!

[pre]

A		B	C		D
Actual		Target	helper column	???
ARD Web		110	157		164
Brutis		9	9		9
CS2		#N/A	#N/A		#N/A
Kiosk		#N/A	1		1
Loyalty		9	16		17
MDM		#N/A	#N/A		#N/A
Qik		#N/A	4		4
.com/WDS	9	12		13
OBS - SMP	24	26		27
EI 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

[/pre]

 

[Faseeh]

Hi gizmo,


This post is for you:


http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/


Regards,

 

[gizmo]

Thank you Faseh, however, i tried using that (as well as a million other things via youtube, etc) but it doesnt work. Maybe b/c i have 3 columns of data i want to chart??? Colunms are the Names, Actual, and Target. Sorry everything shifted so ugly on my post.

 

[SirJB7]

Hi, gizmo!

I've edited your first post. If that's not your worksheet layout or you don't receive any suitable answer, then consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.

Regards!

 

[gizmo]

Thanks SirJB7! here is the file. Think you can help me? i need some help ASAP.


https://www.dropbox.com/s/njfit46f3liy13l/forum%20example.xlsm

 

[SirJB7]

Hi, gizmo!


I can't understand you issue or reproduce it. Your uploaded file ask for an update against an Access database that isn't available so I cancelled that step. After that I changed values in "ARD Web" for "Actual passed" setting them all to zero and then setting the last entry in worksheet "Test metrics" to 15 instead of 123, and in both cases the cell C7 of worksheet "Pivot Data" and the chart there got updated correctly.


Please elaborate you requirements and post or upload the process (step by step) that you'd make to get the error, pointing out explicitly which is the error value got and which should be the right one.


Regards!