Theva
asked on
Forecast data based on Parato chart
Hi Experts,
I would like to request Experts help. How to incorporate 20% of increase for each year (2011,2012 and 2013) based on average rate in the attached chart and need to differentiate the exciting and forecast value clearly. Is that possible to create a pareto chart to show this 20% increment for these forecast year? Hope Experts could help me to create this chart.
Chart-Parato.xls
I would like to request Experts help. How to incorporate 20% of increase for each year (2011,2012 and 2013) based on average rate in the attached chart and need to differentiate the exciting and forecast value clearly. Is that possible to create a pareto chart to show this 20% increment for these forecast year? Hope Experts could help me to create this chart.
Chart-Parato.xls
or this version, with the increase calculated as 20% of the average.
cheers, teylyn
Chart-Parato-v2.xlsx
cheers, teylyn
Chart-Parato-v2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Teylyn/Tils:
Thanks for the brilliant chart, simply amazing.
Thanks for the brilliant chart, simply amazing.
maybe something like this?
cheers, teylyn
Chart-Parato.xlsx