Actual vs Plan

akpofureenughwu — Mon, 03 Oct 2016 04:09:07 GMT

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

Re: Actual vs Plan

m_woolf — Mon, 03 Oct 2016 16:31:07 GMT

In script:

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

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

Then use Type as Dimension for your chart.