Thread: Bar Chart with Secondary Line
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Bar Chart with Secondary Line
Hi,

In order to get the line to run vertically you need to use a xy-scatter
chart type rather than Line.

More information can be found on Jon's site.
http://peltiertech.com/Excel/Charts/BarLineCombo.html

Cheers
Andy

Sliver Rayne wrote:
I'm creating a bar chart that I need to put a secondary axis (line chart) on.
The bar chart is vertical and the line chart is horizontal. How can I get
the secondary line chart to run vertically with the bar chart??

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote