Actual vs Plan

[akpofureenughwu]

Good day everyone..

I have an excel sheet which table contain data variablefor actual and plan.

I would love the actual to be in bar chart and plan in line chart/

How can I do  this?

S/N	Field	January	February
1	Lifting (actual)	12	34
2	Lifting (plan)	60	60

[m_woolf]

In script:

if(index(Field,'(actual'))>0,'Actual',

    if(index(Field,'(plan'))>0,'Plan')) as Type.

Then use Type as Dimension for your chart.