This is so close - I can follow the logic, and I almost could do it, but when
following the directions on the link below, I cannot find the 'paste special'
because there is no Edit menu from which to select it. I did find a paste
special once I had copied the range, but the paste special had aboslutely
nothing like what you wrote. I'm using 2007 - am I totally off-base with the
paste special?

"Jon Peltier" wrote:

Alternatively,

Add a Line to a Column or Line Chart
http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



John Mansfield wrote:
Hello,

One option for emphasizing a line would be to create a combination chart
consisting of columns and a line. Jon Peltier provides an example via the
link below:

http://peltiertech.com/Excel/Charts/ComboChart1.html

Converting your example to Jon's format, you would start with a column chart
consisting of two series - an "A" and "B". The "A" series would consist of
the data you have now. The "B" series would be populated with the value
"1800".

To convert the "B" series to a line, select it by clicking on the "b" series
bars. Then select Chart - Chart Type - Line. You can then emphasize your
line with a different formatting like color or weight.

-------
John Mansfield
http://www.cellmatrix.net


"SKSmith" wrote:

I created a column chart of sums that each of 11 travelers have in their
accounts. The total due is $1800. I have major units in the Axis set at 200.
I would really like to emphasize the 1800 line - not set maximum there, just
emphasize. Max is set at 2000 or possibly 2200. I have seen charts in
magazines where this was done - I do not know if I should use a different
chart type or if there is some way to tweak the column chart. In playing
around I can get that line with different chart types, but then the data
flows downward from that line. Should I just try to simply draw a line and
superimpose it upon the chart? Seems clunky, but I'll do that if necessary.
Any help appreciated.