Hi, hoping someone can help me with a formula I'm having trouble with for a
graph made up of information taken from Excel sheet.

Basically the graph shows total Milestones achieved from all the departments
within my company over the course of a year. I have a line on the graph
showing the total planned milestones and other lines are ready to appear for
actual milestones achieved when information is entered into the excel sheet,
however I would like to have a "target line" on the graph of 85% of the total
milestone planned to show after the year ends if each of the
departments/departments as a whole have achieved the require number of
milestones.

This is the formaula that's in the graph at the minute for the "target
line/Scheduled Achievement Rate" (which was set up by someone else)

=SERIES(Infrast!$A$225,,Infrast!$B$225:$M$225,6)

This formula basically just says to me that cell A225 (in the Infrastructure
worksheet) is the Scheduled Achievement Rate and cells B225-M225 are 85%, but
surely it needs to say 85% off something, like the total milestones planned?

Hope that this makes some kind of sense, appreciate any help you can give.

Gary
--
Project for Work, Cigars for Pleasure