Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
In script:
if(index(Field,'(actual'))>0,'Actual',
if(index(Field,'(plan'))>0,'Plan')) as Type.
Then use Type as Dimension for your chart.