Combo chart with 2D Bar and overlaid line chart in newer excel version

[mbk0523]

Hi, I believe that in Excel 2003 you could make a combination chart with a bar chart (axis is vertical, and the bars are horizontal) and a line chart (the line is vertical). But now in the newer Excel version I'm using (2016? Office365?) you can only do a combo chart when it's a column chart. Does anybody know how to do what I'm looking to do with the bar chart?
Thanks!

 

[BobUmlas]

On the insert tab, click the dialog launcher in the Charts group. Select the 2nd tab, "All Charts", then select Combo at the bottom. Then change the first series to a Clustered bar.

 

[mbk0523]

No, that doesn't work. In your picture, the line series is moving horizontally. But I need it to move vertically. Currently the only way I've been able to do it is to export the chart to my presentation in PPT and rotate the chart there. Would love to know a better way.

 

[BobUmlas]

Line charts always go left to right. Perhaps a scatter would work instead of a line. I think column/line then snipping tool and paste the image and rotate would be easiest!

 

[mbk0523]

In older excel versions I believe you could make line charts vertically. Oh well.
Thanks

 

[Jon Peltier]

No, in older versions and in new versions, to make the line go top to bottom, you had to use an XY Scatter chart series, not a Line chart series. Here's my tutorial:

Bar-Line (XY) Combination Chart in Excel