create a helper column with that value in it for the number of points you
need and add that to the chart as a set of data
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Carlee" wrote:

Hi All,

I am new to excel, so please bare with me.

I have a chart that displays treatment values collected for each month. The
treatment value is the Y Axis, and the dates for a specific month is the X
axis.

Question: I have a budgeted value for each month that is set at the
begining of the year and stored in my workbook. What I want to do is display
the Budgeted value as a horizontal line, whereby the user can view where the
actual value in comparison to the budgeted value.

I have been able to plot the budgeted value as a single point, but cannot
seem to get it to display as solid bar on the graph.

Any ideas?
--
Carlee