Graphs|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Hava,

Select just the Net Sales segment of the column (left click twice, but not double click). Then right-click the Net Sales segment > Change Series Chart Type > Combo, then and select the chart type and secondary axis in the bottom section of the window.

In the attached file there's a screenshot of the menu. I've also included a better chart, because stacked bar/columns aren't very good at allowing comparisons in the data, because only the first segment starts at an equal level, all other segments start at different levels. Better to just use a clustered column chart.

Mynda