Help with a Formula

[Gary]

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

 

[Rhiannon McKay]

You're right. You need to take the 85% of the total milestones planned to
get the "target line". Otherwise you're just graphing the number 0.85 which
would put the line down by your zero line depending on the scale, which I'm
sure would be setting the bar kind of low. Let me know if that works for you.

Rhiannon