Excel Experts assistance.

[Buckwheet]

I hate scatter graphs.

So here is what I have:

Column A is a list of project actions like closed, open, investigation, assigned, Resolved. And each one then has a count for each agent.

So I want to scatter plot agent activity on a weekly basis(the static email report) and track it over 52 weeks in one graph. I can get the weekly graph very easily by doing it every week. The combo graph is what I am having an issue with.

Is this even possible? The table below would be for the week of the 20th.

Agent Activity|Agent A|Agent B|Agent C
Assigned|22|34|50
Pending|1|2|3
Closed|45|50|44

[Bobmuhthol]

You need to pick your axes; you don't have two measurements from what I can see so you have no reason to make a scatter plot. I might be misunderstanding you but it seems like line graphs are what you would want, especially if you want to track time.

If you actually want points instead of a trend line you can make a time dummy and use that as your x axis (week 1 2 3 4 etc.)

[Buckwheet]

Line graphs work but the graph is horribly messy with 40 agents over a 52 week period.

[Celephais]

You need to pick your axes;

http://www.hirestation.co.uk/images/150%20040%20Pick%20Axe.jpg

[AnticorRifling]

Ok need help.

Let's say I've got column A with values of A1= 1600 A2 = 550 A3 = 1200 etc

I want any instance where a cell value is greater than 1000 to change it to a value of 500.

How?

Go!

So the above would change to A1= 500, A2 = 550, A3=500, etc.

[Celephais]

Ok need help.

Let's say I've got column A with values of A1= 1600 A2 = 550 A3 = 1200 etc

I want any instance where a cell value is greater than 1000 to change it to a value of 500.

How?

Go!

So the above would change to A1= 500, A2 = 550, A3=500, etc.

You could write a macro to go through it, but I'm not sure if that's what you're asking for.

You could make column B1's formula = IF(A1 > 1000, 500, A1), then copy the formula down the column and use that column instead (or switch it around so you have a hidden column that is the current values of A and then make A use that basic formula).

[AnticorRifling]

Bah thanks Cel that's what I was after and I was forgetting the A1 after my >1000, 500.

[NocturnalRob]

Bah thanks Cel that's what I was after and I was forgetting the A1 after my >1000, 500.
excel n00b. lrn2formula

[AnticorRifling]

I'll put my formula on your face!

[NocturnalRob]

I'll put my formula on your face!
Is it the CUMPRINC formula?

[AnticorRifling]

Probably more of a NOMGOO.

[NocturnalRob]

Probably more of a NOMGOO.
Good thing I've got my CLEAN formula. Also, I noticed you were working with a SMALL formula there. Very sad.

[AnticorRifling]

You just don't turn me on enough to adjust the column width and cell size.

[NocturnalRob]

It's not my fault all your fonts are Asian.

[Celephais]

http://cdn0.knowyourmeme.com/i/000/049/943/small/HNNNNNNGGG-Oh-hey-guys-whats-goi-HHHHHNNNGGG.jpg

[NocturnalRob]

http://cdn0.knowyourmeme.com/i/000/049/943/small/HNNNNNNGGG-Oh-hey-guys-whats-goi-HHHHHNNNGGG.jpg

Nngh.