Baseline values for comparison
Hi there,
What is a 'helper column', and how would i go about achieving this? I need
to show the baseline value as a horizontal bar, not a veritical one.
Could you assist a bit further?
--
Carlee
"John" wrote:
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
|