MS Excel Graph with dynamic range
Posted on 2011-10-17
Hi guys -
I'm not sure the 'right' wording for what I'm trying to do so I'll try to explain it and see if you can help me.
I have a table of data. In this table I have two series of values that I want to graph (Column A).
But everyday, I'm going to be pasting more data in and having a static range that i set my series on my chart from won't work. So what I'm trying to do is a..
SELECT the series of my worksheet, where the name of my series equals the ProjectName in column A.
A VLOOKUP of sorts?
Or the only other way I can explain..is like when I do a COUNTIFS(RANGE, Criteria...) where "Criteria" would be my value in A.
Is this possible to do in charts so I don't have to specify each range statically?
Thanks so much!