Recent content by jeremymjp

I'm sorry, I don't know why it's behaving this way. Did you do anything like hide the cells where the originals are, or hide the sheets?

Put each of your four charts in their respective information page. Select the CELLS (not the graph object) behind the first graph. Copy the cells. Then, paste+special Linked Picture. It will result in a dragable, resizable image that updates when your graph updates. Click on each image and...

Hui, I haven't seen those. Does your first link display correctly for you? I can't really understand what it's communicating. The comments show that others have had the same problem. Not sure if it's my browser or what. It looks like it could be useful : ) Thanks for the links y'all.

The function NA() returns a value that the chart won't show. So, I don't know exactly how you're implementing what you've got going on, but if you can check ISBLANK() to be TRUE, then run NA(), your graph won't show the value.

Does anyone have a good resource to visually show/learn/explore the VBA object model? I'm looking for a tree map or other diagram that shows even just the popular objects, methods or properties. There are so many that I'm having difficulty with Microsoft's list-based browser. Thanks, JP

If your milestones are happening based on the x-axis, you can size all of the columns behind the graph to equal sizes with your graph intervals. Then, you can make your chart area "no color", so that it becomes transparent and shows the contents of the cells behind the chart. Then, in four...

Make sure that when you highlighted your information and chose to "insert graph", you had two columns with headers highlighted. Then, experiment with changing the graph type. It may be interpreting the series as the column, not the rows. I think you can toggle which axis displays what from...

Asa should be commended for the response shown on this single post... Good job.

Nice, asa. Thanks. I used this tip today for a problem of my own. "Boolean values are ignored by most aggregate functions..." Good to know!

If I understand, yes it is possible. With the formula that you believe is correct but returns a #Ref! error, find out why it's getting an error with the "Evaluate Formula" button in the "Formula" tab of the Excel ribbon. You can watch step by step to see what the formula does to get the error.

What's the outcome when you try it?

Without using IF specifically? Yes. However, the ways I can come up with are still using similar formulas (COUNTIF and SUMIF).

If you know anything about matrices... Entering an array formula is letting Excel know that you're working with matrices. Think of this problem as (for instance, the first login), telling Excel: "Tell me the lowest number in the set of login times where the agent matches the agent I'm...

You're welcome. Yes, there is a fix. But, would you want to capture their first login, last login, first logout or last logout? We can fix the range issue by choosing the entire column. Some people would have an issue with that, but it sounds like you don't have a huge record set. So...

Way to go man.