On Sun, 12 Aug 2007, in microsoft.public.excel.charting,
JN said:

100 200
300 200

I'd like to show a line chart that has Col B as the base line (budget) with
Col A reflecting activity - in the example above, Col B would be "0" on the
chart with Col A1 showing negative (above or under budget) and A2 showing
positive (below or above budget)

Here's what you have to do to get that:

Activity
0 -100
0 100

Type those in, taking care to put "Activity" in the cell above "-100",
then create a chart using the Chart Wizard.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.