Dynamic Graphing - with source data from a "Unique" formula

[Mark McInerney]

Hi Folks,

I have a range of data, that I use to retrieve data, that I then use for a graph in excel. I use the unique function as part of the data retrieval.

This means that the data populates differently depending on the criteria that I use with the "Unique" formula.

The data can populate from a1:a10, and then a1:a45 - is there a way that I can link the populated data range to the graph without having to map all the blanks - to capture all data I would have to define my source range as a1:a45, but when the data returned can be a1:a10, the graph looks very empty.

I only want to graph the range of data that is populated with values?

Thanks for any help.

 

[Cubist]

Try this Youtube video.

 

[Mark McInerney]

Hi Cubist,

Thanks for having a look - it is not working out. I am, and was, using a unique and filter function to extract data, but I also have to use a sumifs to get the sales total - it is still mapping the blanks?

 

[Cubist]

Can you post sample data? Preferable using XL2BB.

 

[Mark McInerney]

XL2BB........No idea what that is...sorry.

This is the data with the unique filter formula:

As I change Cell L4 the list of subdepartments changes - some departments have 5 subdepartments, others have 25.

I'm trying to dynamically map the sales - the column headers are MULLI and 20 - DCF below.

Just trying to get rid of the blanks that are being mapped when I change the selection - see below - Thanks - Mark.

 

[Cubist]

XL2BB is an add-ins of the forum that allows you to post mini sheets with its formula like this. You should see the "XL2BB" link to the far right of your reply box. It has instructions on how to set it up.

Book3
	A	B	C	D	E
1	A	25		Condition	A
2	A	26
3	A	27		A	25
4	C	28		A	26
5	K	29		A	27
Sheet1

Cell Formulas
Range	Formula
D3:E5	D3	=FILTER(A1:B6,A1:A6=E1)
Dynamic array formulas.

Pivot chart seems to be a better option.