• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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
0
Theva
Asked:
Theva
  • 3
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello Theva,

maybe something like this?

cheers, teylyn
Chart-Parato.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
or this version, with the increase calculated as 20% of the average.

cheers, teylyn
Chart-Parato-v2.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
third time lucky. I mixed up the price and quantity data in the previous two charts. Sorry. See this for a better approach.

cheers, teylyn
Chart-Parato-v3.xlsx
0
 
tilsantCommented:
Hi Theva,
May be you can also use/show the values from the FORECAST worksheet function.

Also, in case if you need to change the 20% to a different value then just change the value in cell A6.



Tils.

Copy-of-Chart-Parato.xls
0
 
ThevaAuthor Commented:
Hi Teylyn/Tils:

Thanks  for the brilliant chart, simply amazing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now