Recent content by jcalvacca

Woo Hoo. Thank you @PCosta87 ! I completely forgot the special click to create an array

Hello all and thanks in advance for the help! See attached file. -B:B will be the date of the data capture. -C:C will be the dollar amount of data. -A:A is being used to determine if the data is within the last 12 months of the current entry(last row entry) Columns O and P will be used to...

Hello all! Thanks for the help. I have attached a file for reference with some comments... Few things to note.... -Filtering is done so that it can be charted as two separate data blocks.... -Needs to be able to take more data than is posted, so the "blank data" on the end of the copied...

@vletm I'm sure I am..... See attached, I got it to this point..... Complete data to be charted is in A:C, out to row 424 (needs to be able to go that long)... Filtered out as previous examples to F:I and K:N respectively...... Have the chart look like the ones you made last week :-) Thanks...

@vletm Correct! Ok, how do I deal with 'space' in between, or perhaps I need to do one more =Value() than to turn the 'space' into 'blank'......

@vletm How did you handle the blank spaces in the data not to chart....I understand all the rest of the logic with having the two series but I'm struggling having the chart skip over the " " cells.....thanks.

@vletm Thank you!!

@vletm Close..... One step further..... "Vendor" in a different color on top of the existing data....

@vletm See attached picture of vision..... One series is fine..... Data will most likely have blank lines in between like in example....

@vletm Thanks for the reply ;) It doesn't need to be laid out that way for data, I can lay it out anyway it needs to be as it will be imported from different part of the spreadsheet. I believe they will want the x axis to be the "date" analyzed and then the 3 dots stacked up on that date...

@vletm Not new case, different version..... Those two topics will be the "end" of project if I continue on same path. I "hope" it can be simplified with the two of us but I have to be prepared in case it can't be :(

@vletm As far as user, they will use the individual tabs to put in data (-70,-71,-72,etc) They will also use the ending "Charts" to review..... All the rest of the tabs is "behind the scenes" stuff.....so REF Charts is a behind the scenes sheet that gets the data ready for charting...user will...

Hello all and thanks! See attached for vision.... Have test scores from two different locations and would like to use the data for further analysis...... Possibly a macro but not sure if it is....... Project has only two locations but many more charts in different locations on the sheet so an...

So in this line.... =IF('-700'!$A$10="Ebco",'-700'!$B$10," ") tests something just on a sheet named '-700' I would like this line to be dynamic to look at the same cell on several different sheets....for example: =IF('-700'!$A$10="Ebco",'-700'!$B$10," ") =IF('-70'!$A$10="Ebco",'-70'!$B$10,"...

Hello all, I have attached a file for reference...... Chart needs to have date on the left and a value on the right.... Will have "blank space" in between entries as shown...... Only values on the x axis will be the dates in the column, no blanks in between and no space, looks like here the...