For anyone interested I fixed it by adding the following code in combination with my Formula in a Named Range which is "ChartFormula".
Sub UpdateChartSourceData()
With ActiveSheet
.ChartObjects(1).Chart.SetSourceData _
Source:=.Range("ChartFormula"), _
PlotBy:=xlColumns...
Also, I have tried to just add a name in Insert -> Names -> Define and added the formula to the name but it does not stay there. Every time I change the days or number of agents the graph does not update and when I go into the graph the formula does not refer to the name, it just has the...
Hi Glen.
Thanks for that.
I actually tried that but found that by putting the formula in a named cell it tries to return the result of the formula. Since the range takes up many cells it comes back with
#VALUE!
I also got some code off google to craete a function that displays the formula...
Hi guys.
I haven't posted anything here for years so sorry if this has come up before.
I have a report in excel used in a call centre that tracks the number of calls an agent makes. Team Leaders want to see performance by month on a chart.
I have a chart that has an offset formula to change...
Hi.
I have Win XP Home (I know its not pro but I couldn't find an XP home forum) and I have a wierd problem.
With some of my applications, when I open them they flash up for a second and then close down again automatically and I can't get them to stay open.
The applications are completely...
Ok. This is the run down.
I do the reporting and statistics for a call centre and the agents are measured on things such as the time spent working on calls, and after calls.
We are using a Rockwell switch and it is very smart and records every single thing that happens, including touchpad...
Only thig is I need to look at a) while I am at c). In the below example I need to be able to write a formula that says "if a is "unavailable" or "available" (there are numeric codes for each of these) then display that state next to c)"
a) Available
b)...
LOL, sorry I confused you.
I put the "X" there to show you where the cursor stopped when I got the error message. It is saying that where the X is, the system is expecting a variable name.
Hope this makes a little more sense.
Thanks
The simple things are usually the ones that get me !!
Thanks for that.
Now I am having trouble with the second part. I have copied Dgillz formula straight over and replaced it with my field names and I get an error message saying "a variable name is expected here" and the cursor...
Hey Dgillz thanks for your response (and sorry it has taken me so long to get back to this - my boss threw a new piece of work at me).
I am totally unfamamilliar with using variables so I just copied your text and pasted it in, and changed the {YourFieldName} to my field name which is...
Hi.
I need to compare a cuurent record to a record 2 records back. Obviously I can get 1 back by using the "previous" command but I don't know how to go further.
I tried to create a calculated field @previous1 and then take a previous of that field by creating @previous2 but it did...
Dgills:
I actually tried that first and I got pages of blank rows, and data in the calculated field every now and then. It seems to still create a record for the cell I supress but it is invisible.
Bennie47250:
You could be right but I am not really experienced in linking tables. Sure I know...
Hi.
I am trying to modify a report by displaying 3 calculated fileds on it. Not all calculated fields will return a value, and I only want the fileds that do have a value to be displayed. ie. I do not want any records on the whole report unless there is data in the calculated colums.
So I...
I have just imported my mail, address book and accounts from outlook express to outlook 2000.
In Out Exp when I typed in the first letter of anyone in the contacts list of my address book their name would automatically populate. This feature does not seem to be working with Outlook 2000...
Hi.
I have a report that runs every day for yeasterday and I need to be able to change it to a demand report so that I can run it for a selected day.
I have deleted the
VW_EVT_AGENT_ACTIVITY."AA_TIME_STAMP" >= TRUNC(SYSDATE) -1 AND
VW_EVT_AGENT_ACTIVITY."AA_TIME_STAMP"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.