View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Add a Horizontal Line to a Column Chart in XL 2007

Sure it does. The various commands are no longer found on the familiar
toolbars and dialogs, but in general the protocol works fine.

Create a column chart.
Copy the XY data, Select the chart, Paste Special as New Series.
Convert added series to XY type.
Remove secondary Y axis, format secondary X axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Fabio Coatis" wrote in message
oups.com...
Hi,

John Peltierīs method (
http://peltiertech.com/Excel/Charts/...orzSeries.html)
doesnīt work in xl 2007, any comments?

TIA