Need help

[N Schei]

I have a spreadsheet where your are supposed too archive curtain goals,
based on different activities.
I've got six different colums taht shows the activities, I wanna' have a
line that shows how the activites mesures up to the goal.

Ex. the goal (and the line) is to run 12 times a month, but you only run
seven (activities)

Anybody who could help,

thanks

Ns

 

[JulieD]

Hi

i'll need to know more about your worksheet structure as i can't figure out
how you know what the goal is ... could you post back with something similar
to this showing your structure
e.g.
...........A.........B...................C...........D...............E
1.....name....activity name...goal......actual.........variance

please don't attach a workbook.

Cheers
JulieD

 

[Debra Dalgleish]

As answered in microsoft.public.excel.charting:

Jon Peltier has instructions for adding a horizontal line to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine

 

[N Schei]

Hi,
it kinda' looks like this -
on the "sum up" sheet I wanna' have a line that shows the "goal" that we
have agreed on.
Example: there is a goal that each individual have a goal of running
twenty times a month - every person have their own colour - so I can see
who's makeing what. All the peoples activities sums up on the front sheet.
I "just" wanna put a 'budgetline' on each activity so I see how the
activities is being done, according to the goals established.

And thanks for you tips on not putting the same questions in different ng.

Cheers
Nikki