Hi all,
I need to do a graph with sales by products (barrs) and in the second axis net sales (line chart) , but didn´t work.
Can you help me please? (see in attach)
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
Many thanks Mynda 🙂
Very helpful.
Thanks,
Hava