Can you set a goal in a chart. Example tracking sales and amount of sales is
20 but have a goal set of 35 can this be done. Thanks
--
Larry

Yes, you could make your "actual sales" one data series and your "goal or
budget sales" another data series. You could even make the different data
series different chart types if you wanted (Maybe a column for actuals and a
line for goal). You will have to list a goal # for each actual that you have
however in your source data.

Hope this helps.

Bill Horton

"Larry" wrote:

Can you set a goal in a chart. Example tracking sales and amount of sales is
20 but have a goal set of 35 can this be done. Thanks
--
Larry

Larry:

You can add a horizontal line to show your goal. here's a link to an example
horizontal line. You specify the line with just two points (begin and end).

http://processtrends.com/pg_charts_horizontal_line.htm

Kelly


"Larry" wrote in message
...
Can you set a goal in a chart. Example tracking sales and amount of sales
is
20 but have a goal set of 35 can this be done. Thanks
--
Larry