Forum

Notifications
Clear all

Graphs

3 Posts
2 Users
0 Reactions
61 Views
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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)

 
Posted : 27/02/2018 6:32 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 27/02/2018 8:11 pm
(@hava)
Posts: 41
Trusted Member
Topic starter
 

Many thanks Mynda 🙂

Very helpful.

 

Thanks,

 

Hava

 
Posted : 28/02/2018 5:30 pm
Share: