Stacked bar and line charts

This type of chart is not included in the list of chart types available in Numbers, but you might be able to create one using a Stacked Bar Chart and a Line chart, scaling them to match the positions of columns and of data points on the line chart, and placing one in front of the other.

Assuming you do not want the line to disappear behind the vertical bars when they cross, place the line chart in front of the bar chart, remove all elements of the line chart that would distract from the overall appearance of the finished chart, then lock the positions of both charts, or try Grouping them to keep each in the same position wrt the other.

Regards,

Barry

"Excel does."

Numbers is not an MS Excel clone, nor, going by observation, is it intended to be one.

If you need the features that Excel provides, you could purchase Excel for Mac or subscribe to the online version of Excel.

If budget considerations point in other directions, you might want to explore applications that do more closely follow the MS Excel example. Libre Office.org and Apache Open Office (openoffice.org)are two examples.

I've not looked at them lately, but when I last did, Libre seemed to have the more active development plan. Checked just now and see that OpenOffice releases a new version—4.1.14

Regards,

Barry

If you want Apple to get your feedback then you can consider going in your menu to Numbers > Provide Numbers Feedback in your menu

SG