Single axis-Layout
Hello everyone, Please find the atatched workbook. I need to get the layout in the attached format(Mockup). Kindly help me out.
everything should be in single axis.
Regards,
Koushik.
-
-
2. Re: Single axis-Layout
Hi ZZ thanks for the reply. I need profit ratio inplace of profit.
Sales should be cumulative(Running total).
Profit ration in %
quantity as sum(quantity)
Regards,
Koushik
-
3. Re: Single axis-Layout
Zhouyi Zhang
Feb 11, 2019 4:38 AM
Hi, Koushik
The only workaround I could think of is to use the reference line for sales as shown below
Hope this helps
ZZ
-
-
-
6. Re: Single axis-Layout
Hi ZZ, can we have a color code on subcategory for running total sales(Reference Line)? Color partition should be on subcategory for sales refrence line?
-
-
8. Re: Single axis-Layout
when i try to implement refrence line , i am getting % and numbers in axis, how can i restrict only to profit ratio %
-
9. Re: Single axis-Layout
Hi Koushik,
Have attached workaround in workbook attached (2018.2) version. Hope it will help you, in that case you can mark it answered.
-
10. Re: Single axis-Layout
Hi sajad, thanks for the workaround.I need to show profit ratio instead of profit I am able to achieve taking profit
any workaround with profit ratio? Kindly send the workbook in 10.4 version
Regards,
Koushik.
-
11. Re: Single axis-Layout
Zhouyi Zhang
Feb 11, 2019 7:45 PM
1 of 1 people found this helpfulyou need drag the profit ratio in the rows so that it can be an axis.
ZZ
-
12. Re: Single axis-Layout
got it ZZ, previously i was taking Reference line from profit ratio thats the reason coudlnt able to achieve it... Thanks
-
13. Re: Single axis-Layout
Zhouyi Zhang
Feb 11, 2019 10:08 PM
No worries, let me know if you have further question.
ZZ
-
14. Re: Single axis-Layout
No further questions ZZ. thanks for the workaround.Marked answer as helpful.
