graph selection based on criteria

[lucigen]

Alright so I am trying to automate the creation of a bar graph where each data entry has 3 columns of data

ex: label at B2, data in C2, D2, E2

In A2 there is a data value, and if it is something other than blank then the data gets added to the graph, otherwise it is not included in the data set.

The other problem is that in the general case I dont know how many rows down this set of data goes. The data is generated by another macro so it needs to be flexible

I would try to post code but I don't really have any idea what to do here, first experience trying to make visuals

Any help would be vastly appreciated!!

 

[Steve=True]

You don't need a macro for the graph.

Just use Offset, Count and Index/Match in a name for your chart series.

Put this in a name. make a chart and change the series to the name you created.

This formula uses offset starting a the top point, then goes down to the end of the data using count.

=OFFSET('Using Offset Formula'!$G$6,0,0,COUNTA('Using Offset Formula'!$G$6:$G$14),1)

you can find more on chandoo.org search for dyanmic-chart-tutorial.xlsx

 

[lucigen]

Hey thanks!

worked like a charm, I had to redo part of the other bit to make it skip some rows, but thats awesome.

Also I appreciate the super fast reply too!

 

[Steve=True]

Thanks for the nice note. Enjoy!