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

mbk0523

New Member
Joined
Aug 29, 2012
Messages
19
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!
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

BobUmlas

Well-known Member
Joined
Mar 14, 2002
Messages
1,181
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.
 

Attachments

  • Capture.JPG
    Capture.JPG
    58.6 KB · Views: 2

mbk0523

New Member
Joined
Aug 29, 2012
Messages
19
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.
 

Attachments

  • Untitled.png
    Untitled.png
    16.9 KB · Views: 0

BobUmlas

Well-known Member
Joined
Mar 14, 2002
Messages
1,181
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

New Member
Joined
Aug 29, 2012
Messages
19
In older excel versions I believe you could make line charts vertically. Oh well.
Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,122,356
Messages
5,595,681
Members
414,009
Latest member
SNesbyCarr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top